I have a column where I enter a date when the event happens (local storage), and the date the event is sent to my system.
The difference between the date of the event and the date of submission can not exceed 168 hours (7 days).
I'd like to select all the data that the + 168h event data is smaller than the send data.
SELECT * FROM VENDA
WHERE (DATA_VENDA+ 168HOURAS) < DATA_ENVIO_VENDA;
I'm using Oracle database.