Hi,
I need a SQL statement as this:
SELECT Field1, Field2,... FROM Table1
WHERE (...) and DateTimeField1 + 4 hours > Now
As you can guess this is used to raise an event to control
a process which needs 4 hours to be completed.
My problem is that I do not find the way to
compare the dates/times, they are not numbers inside SQL ...
I've seen you can extract the time using
EXTRACT(Time From DateTimeField1) but what to write in
the right part of the operator?
Thanks in advance,
Dani.
I need a SQL statement as this:
SELECT Field1, Field2,... FROM Table1
WHERE (...) and DateTimeField1 + 4 hours > Now
As you can guess this is used to raise an event to control
a process which needs 4 hours to be completed.
My problem is that I do not find the way to
compare the dates/times, they are not numbers inside SQL ...
I've seen you can extract the time using
EXTRACT(Time From DateTimeField1) but what to write in
the right part of the operator?
Thanks in advance,
Dani.