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: First date of a month

Re: First date of a month

From: Michael Seagal <socio_at_vis.infotel.ru>
Date: Tue, 22 Feb 2000 14:43:22 +0400
Message-ID: <38B2684A.656EF757@vis.infotel.ru>


TRUNC(SYSDATE,'MM') Norazman wrote:

> Hi how to get the firts day date of the month in SQL.
> Ie since today is feb so it should be 01-feb-2000
> thanks
>
> azman

Michael


Received on Tue Feb 22 2000 - 04:43:22 CST

Original text of this message

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