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