Convert string with time zone offset to datetime in Athena
There is a column of type varchar in MySQL table that contains datetime data like
‘2021-08-17 06:55:22.819-0400’ which has the time zone offset information included.
There is a column of type varchar in MySQL table that contains datetime data like
‘2021-08-17 06:55:22.819-0400’ which has the time zone offset information included.