C
Craig P
Guest
I have a query which calls results from the last day, but I would like to only call the last hour. Its from a Progress OpenEdge 11.2 database.
The current code to call the past day
(T1.created_date_time BETWEEN TO_CHAR(CURDATE() - 1, 'yyyy-mm-dd') + ' '
+ '00:00:00' AND TO_CHAR(CURDATE(), 'yyyy-mm-dd') + ' ' + '23:59:59')
I think the query is TO_CHAR(CURTIME(), 'hh:mm:ss' -1) but I couldn't get it right.
Continue reading...
The current code to call the past day
(T1.created_date_time BETWEEN TO_CHAR(CURDATE() - 1, 'yyyy-mm-dd') + ' '
+ '00:00:00' AND TO_CHAR(CURDATE(), 'yyyy-mm-dd') + ' ' + '23:59:59')
I think the query is TO_CHAR(CURTIME(), 'hh:mm:ss' -1) but I couldn't get it right.
Continue reading...