I would do date_parse. Adjust your regex accordingly. select date_parse('Nov-06-2015','%b-%d-%Y'). 2015-11-06 00:00:00.000.Athena date format unable to convert string to date ...4 answers
amazon-athena-cast-string-to-date
Feb 8, 2019 — With Athena, I got some answers out of several years of log data in S3 ... by date, and it supports parallelized reading and querying of the files, ... One sticky point was the ELB status code, which needed to be cast from string to ... 3925e8d270
amazon athena convert string to date
Comments