Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle Date Functions
In article <8hjid1$f33$1_at_nnrp1.deja.com>,
firozahmad_at_my-deja.com wrote:
> Is there any SQL Query anybody has written which can find the Next
> Months First Days Date.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
select trunc( add_months(sysdate,1), 'MONTH' ) from dual;
-- Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries Howtos and such: http://osi.oracle.com/~tkyte/index.html Oracle Magazine: http://www.oracle.com/oramag Opinions are mine and do not necessarily reflect those of Oracle Corp Sent via Deja.com http://www.deja.com/ Before you buy.Received on Tue Jun 06 2000 - 00:00:00 CDT