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

Subtract 1 month add 1 day..

select add_months(last_day(your_date),-1)+1 from dual

ramsey84_at_my-deja.com wrote in message <7sjjhb$if6$1_at_nnrp1.deja.com>...
>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!
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sat Sep 25 1999 - 19:51:44 CDT