Re: Last_Day...but is there a First_Day?

In article <7sjjhb$if6$1_at_nnrp1.deja.com>, ramsey84_at_my-deja.com writes
>Does anyone know the best way to return the first day of the month for
>a date field. For instance if
>
>15:37:40 SQL> select last_day(sysdate) from dual;
>
>LAST_DAY(
>---------
>30-SEP-99
>
>how would I get the output to be 01-SEP-99, instead? TIA!
>

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

Andy
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
Andy Hardy. PGP key available on request