Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: First date of a month
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