Re: First day date of a month

select trunc(sysdate,'month') from dual;

--
Have a nice day
Michel

Norazman <norazman_at_ti.com> a écrit dans le message : 38B2646F.D3B92E05_at_ti.com...
> 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
>
>
Received on Tue Feb 22 2000 - 04:33:00 CST