Hi everyone, I’m very new at SQL queries…I’m learning as I go.
I know this should be easy but every day I’m making improvement.
I built this query and my date results include time, minutes second. I’d like to get rid of that.
This is what I have as my date range and the returned values.
where e.start_date_time >=to_date(‘2014-01-01’, ‘YYYY-MM-DD’) and e.start_date_time <=to_date(‘2014-12-31’, ‘YYYY-MM-DD’
These are the result for e_start_date_time
2014/01/01 1:53:33 PM
How do I truncate to YYYY/MM/DD?
Where do I go from there?