12

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"
Manfred Moser
  • 29,539
  • 13
  • 92
  • 123
user8818601
  • 123
  • 1
  • 1
  • 6

2 Answers2

17

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

Piotr Findeisen
  • 19,480
  • 2
  • 52
  • 82
4

You can use the date_format function (docs here: https://prestodb.io/docs/current/functions/datetime.html)

Here's an example:

date_format(charges.created, '%Y-%m') as rev_month

If for some reason you're comparing dates you don't need to do the conversion like that, you can do the following

where customers.created BETWEEN timestamp '2018-04-01 00:00:00.000' AND timestamp '2018-05-01 00:00:00.000'
DougB
  • 674
  • 7
  • 14