Skip to content

Instantly share code, notes, and snippets.

@yucer-elbt

yucer-elbt/athena_query_iso8601_opt_seconds.sql

Created September 20, 2022 08:16
Show Gist options
  • Save yucer-elbt/c6e2a638a9ae0019cf5ce74af8f00366 to your computer and use it in GitHub Desktop.
Save yucer-elbt/c6e2a638a9ae0019cf5ce74af8f00366 to your computer and use it in GitHub Desktop.
Download ZIP
iso8601 in athena queries: optional seconds and microseconds in UTC
Raw
athena_query_iso8601_opt_seconds.sql
select format_datetime(current_timestamp, 'YYYY-MM-dd''T''HH:mm''Z''')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment