Amazon Athena - Converting Timestamp to Date?

Question

Looking at the Date/Time Athena documentation, I don't see a function to do this, which surprises me. The closest I see is date_trunc('week', timestamp) but that results in something like 2017-07-09 00:00:00.000 while I would like the format to be 2017-07-09

Is there an easy function to convert a timestamp to a date?

Answer 1

The reason for not having a conversion function is, that this can be achieved with a type cast.

So a converting query would look like this:

select DATE(current_timestamp)