Skip to content

Instantly share code, notes, and snippets.

@thangarajan8

thangarajan8/multiple_date_format.sql

Last active September 15, 2021 11:16
Show Gist options
  • Save thangarajan8/b6e77fd40c4b098e4df0cc1b34880477 to your computer and use it in GitHub Desktop.
Save thangarajan8/b6e77fd40c4b098e4df0cc1b34880477 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
multiple_date_format.sql
SELECT *
FROM
(
SELECT '2021-01-15 13:01:01' AS multi_date_format
UNION ALL
SELECT '2021/01/15 13:01:02'
UNION ALL
SELECT '2021/01/03'
UNION ALL
SELECT '04 JAN 2021'
UNION ALL
SELECT '05 JAN 2021 13:01:05'
UNION ALL
SELECT '06/01/2021 13:01:06'
UNION ALL
SELECT '07-01-2021 13:01:07'
) AS multi_date
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment