Skip to content

Instantly share code, notes, and snippets.

@yucer

yucer/athena_query_iso8601_opt_seconds.sql

Created April 15, 2023 15:43
Show Gist options
  • Save yucer/7b5e3ee6c86de955fd6ed9852809bc7a to your computer and use it in GitHub Desktop.
Save yucer/7b5e3ee6c86de955fd6ed9852809bc7a 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