Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: simple way to compare date "intervals"

RE: simple way to compare date "intervals"

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Thu, 2 Sep 2004 16:23:39 -0400
Message-ID: <80D4A99A2715674EB2D256DAD89219F6044E8DBD@dohsmailhq04.doh.ad.state.fl.us>


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_at_freelists.org&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004
Received on Thu Sep 02 2004 - 19:42:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US