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 -> Re: Get today's month - 6?

Re: Get today's month - 6?

From: Mih <mih_at_post.dk>
Date: Thu, 25 Nov 1999 12:06:18 +0100
Message-ID: <81j5db$hhi$1@news1.tele.dk> 






select add_months(sysdate,-6) from dual ;



suisum_at_ecn.ab.ca wrote in message <383d0891.0_at_ecn.ab.ca>...


>How to get the date of SYSDATE - 6 months?


>


>--


>Best regards,




Received on Thu Nov 25 1999 - 05:06:18 CST












Original text of this message













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