Skip to content

Instantly share code, notes, and snippets.

@gnuton

gnuton/PSQL Iso week conversion

Created May 19, 2021 04:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gnuton/d7feae45553277f35ec6888deeb77cfb to your computer and use it in GitHub Desktop.
Save gnuton/d7feae45553277f35ec6888deeb77cfb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
PSQL Iso week conversion
postgres=# SELECT TO_DATE('2020-W53','YYYY-XWW');
-[ RECORD 1 ]-------
to_date | 2020-12-30
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment