Get current date with time 00:00:00/23:59:59

Question

:)

I'm running queries on AWS Athena and want to check whether a certain datetime (Year-Month-Day Hour-Minute-Second) is within the current date's 00:00:00 - 23:59:59 time interval. I checked presto's documentation, but can not figure out how to pull that off in presto.

Does anyone have an idea on how this could be achieved?

Thank you!

user_6774538 · Answer

you can do

select mydate >= date_trunc('day', current_timestamp) and mydate < date_trunc('day', current_timestamp+interval '1' day)

see the date_trunc docs: https://prestodb.io/docs/current/functions/datetime.html

Get current date with time 00:00:00/23:59:59

1 Answers