티스토리 뷰

공부

[Presto] convert date to string

승가비 2020. 11. 27. 10:48
728x90
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

 

728x90
저작자표시 비영리

'공부' 카테고리의 다른 글

[Docker] docker attach ${name}  (0) 2020.11.28
[Kafka] describe & delete  (0) 2020.11.28
[Java] Jackson Json <-> Object & hash MD5  (0) 2020.11.27
[Django] timezone.localtime(timezone.now())  (0) 2020.11.27
[Java] StringUtils.split separators 임 사용에 주의  (0) 2020.11.26
댓글