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

Home -> Community -> Usenet -> c.d.o.misc -> Subtract Hours From A Given Date

Subtract Hours From A Given Date

From: Harvey <pfeffer.david.da_at_bhp.com.au>
Date: Fri, 10 Sep 1999 15:14:54 +1000
Message-ID: <7ra4a8$a3d12@atbhp.corpmel.bhp.com.au> 





Does anyone know how to subtract hours from a given datetime in Oracle?



 Is there a function similar to add_months?...ie ADD_MONTHS(sysdate,-6) will
return a date 6 months before the current date.


Received on Fri Sep 10 1999 - 00:14:54 CDT












Original text of this message













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