How to compare two Oracle Datetime columns

Question

I have a column where I enter a date when the event happens (local storage), and the date when the event is sent to my system.

The difference between the date of the event and the date of dispatch must not exceed 168 hours (7 days).

I would like to select all the data that event data + 168h is less than the shipping data.

SELECT * FROM VENDA
WHERE (DATA_VENDA+ 168HOURAS) < DATA_ENVIO_VENDA;

I’m using Oracle database.

Answer 1

You can add 7 days which is the equivalent of 168h:

Sqlfiddle - Online Example:

SELECT * FROM VENDA WHERE (DATA_VENDA + 7) < DATA_ENVIO_VENDA