Question: 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.

Answer: 
You can use like

```
timestamp > to_timestamp(sysdate-1)

```
You can do this:

timestamp > cast(sysdate-1 as timestamp)