View Single Post
 
Old February 4th, 2004, 01:55 AM
mcmouli mcmouli is offline
Registered User
 
Join Date: Feb 2004
Location: KL, , Malaysia.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to mcmouli
Default How to subtract hours from sysdate in oracle

I want a query.
I have a date column in one table. Now I want compare this date with (sysdate - 50 hours). How to write query.
How to subtract required hours from the sysdate
Thank you
Mouli