[Presto] convert date to string
select date_parse('7/22/2016 6:05:04 PM','%m/%d/%Y %h:%i:%s %p')https://stackoverflow.com/questions/39880540/presto-sql-converting-a-date-string-to-date-format
Presto SQL - Converting a date string to date format
I'm on presto and have a date formatted as varchar that looks like - 7/14/2015 8:22:39 AM I've looked the presto docs and tried various things(cast, date_format, using split_part to parse and then
stackoverflow.com
https://prestodb.io/docs/current/functions/datetime.html
8.13. Date and Time Functions and Operators — Presto 0.244 Documentation
MySQL Date Functions The functions in this section use a format string that is compatible with the MySQL date_parse and str_to_date functions. The following table, based on the MySQL manual, describes the format specifiers: Specifier Description %a Abbrevi
prestodb.io