RE: simple way to compare date "intervals"
- From: <Paula_Stankus@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 2 Sep 2004 16:23:39 -0400
Would like to know if there is anyway to get 4 hours from sysdate for a =
comparison:
Have this but then have to convert back to date
select =
to_char(sysdate-(3/24),'MM/DD/YY:HH'),to_char(sysdate,'MM/DD/YY:HH') =
from
dual
/
---
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To read recent messages - //freelists.org/archives/oracle-l/09-2004
Other related posts:
