Date manipulation .......

[Gabriel Fox]

I have a date field, fieldA in TableA of my Oracle DB. How do i query this table to
retrieve records with dates(i.e. fieldA ) 30minutes less than
the SysDate(i.e. current date-time).All ideas are welcomed.

[SJ Adnams]

select * from foo where fieldA < (sysdate - 0.02083);
(that is oracle specific, db2 works in seconds? AFAIK)

[Gabriel Fox]

Cheers,But
How did U get 0.02083, what is the conversion standard.

[SJ Adnams]

oracle works in days so 0.5/24 = oracle works in days so 0.5/24 = 0.02..

[Gabriel Fox]

Cheers Mate!