Followup
Stuti Aggarwal, September 09, 2016 - 5:02 pm UTC
I would need the first part.. my requirement is that for the cuurent_timestamp i want to go 1 hr back trunc to hr part only..dont need mins
September 10, 2016 - 8:39 am UTC
In that case, it is simply
[yourdate]-1/24
and then the same functions Chris described before.
Cheers,
Connor
Thanks
Stuti, September 10, 2016 - 10:04 am UTC
I got that..