Skip to content

Instantly share code, notes, and snippets.

@yucer

yucer/presto_iso8601_basic_format.sql

Created April 15, 2023 15:41
Show Gist options
  • Save yucer/21e7f65e93c1b41471462613ad1b946e to your computer and use it in GitHub Desktop.
Save yucer/21e7f65e93c1b41471462613ad1b946e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
presto_iso8601_basic_format.sql
WITH CTE AS (
SELECT
concat(
substr('20220416T070044.243Z', 1, 4), '-',
substr('20220416T070044.243Z', 5, 2), '-',
substr('20220416T070044.243Z', 7, 2), 'T',
substr('20220416T070044.243Z', 10, 2), ':',
substr('20220416T070044.243Z', 12, 2), ':',
substr('20220416T070044.243Z', 14)
) as ts
)
select from_iso8601_timestamp(ts) from CTE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment