Re: First day date of a month

[Quoted] [Quoted] select to_char(trunc(sysdate,'YYYY-MM')) from dual;

[Quoted] [Quoted] Sorry to correct an employee of Oracle.

Regards,

Sybrand Bakker, Oracle DBA

Brian Duff <bduff_at_uk.oracle.com> wrote in message news:38B3FEE8.2A14AC8C_at_uk.oracle.com...
> 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
>
> select TO_DATE('01-' || TO_CHAR(sysdate, 'MON-YYYY'), 'DD-MON-YYYY')
> from dual
>
> Brian
>
Received on Wed Feb 23 2000 - 18:35:39 CET