multiple_date_format_answer.sql

SELECT 
       Coalesce(
         try(date_parse(multi_date_format, '%Y-%m-%d %H:%i:%s')),
         try(date_parse(multi_date_format, '%Y/%m/%d %H:%i:%s')),
         try(date_parse(multi_date_format, '%Y/%m/%d')),
         try(date_parse(multi_date_format, '%d %M %Y')),
         try(date_parse(multi_date_format, '%d %M %Y %H:%i:%s')),
         try(date_parse(multi_date_format, '%d/%m/%Y %H:%i:%s')),
         try(date_parse(multi_date_format, '%d-%m-%Y %H:%i:%s'))
       )  as DateConvertedToTimestamp,
       multi_date_format from (
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)