Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Get today's month - 6?
Hello,
you can use the ADD_MONTHS ( <Date> , <Months> ) - Function,
in your case i.e.: select add_months ( sysdate, -6 ) from dual in SQL*Plus
or
x_date := add_months ( y_date, - 6); in PL/SQL
Greetinx
<suisum_at_ecn.ab.ca> schrieb in im Newsbeitrag: 383d0891.0_at_ecn.ab.ca...
> How to get the date of SYSDATE - 6 months?
>
> --
> Best regards,
Received on Thu Nov 25 1999 - 04:37:16 CST