How to convert timestamp to date in Presto?

sql presto trino
user8818601 picture user8818601 · Oct 23, 2017 · Viewed 25.5k times · Source

I like to convert my timestamp columns to date and time format. How should I write the query from presto? my timestamp is UTC time. Thank you very much

Timestamp format"1506929478589"
After query convert it looks like "2016-10-25 21:04:08.436"

Answer

Piotr Findeisen picture Piotr Findeisen · Oct 23, 2017

You can convert timestamp to date with cast(col as date) or date(col).

Related questions

Finding out the data type of a value in Presto

I'm getting values from nested maps and it's hard to figure out what data type each value is. Is there a typeof function that can tell me the data type of each value?

Read More
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 cast) and am not getting this …

Read More
Presto check if NULL and return default (NVL analog)

Is there any analog of NVL in Presto DB? I need to check if a field is NULL and return a default value. I solve this somehow like this: SELECT CASE WHEN my_field is null THEN 0 ELSE my_field …

Read More