Is it a simple way to compare is field of TIMESTAMP type get into last n hours? I can do the calculation based on the day and time, but is it possible something like
timestamp > SYSDATE - 1
(SYSDATE - 1) is yesterday, as far as understand, so that will check if timestamp is within the last 24 hours.
Thanks in advance.
If you need to look for records within the last n hour, then subtract a time interval from the current time. For Oracle, the quantity of the interval must be in single quotes. There are many intervals you can use (hour, minute, second, day, year, month).
timestampfield > current_timestamp - interval '1' hour
You can add/subtract non-integers too, e.g.:
SELECT SYSDATE - 0.5 FROM dual;
means 12 hours before now.
You can use like
timestamp > to_timestamp(sysdate-1)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With