Couldn't you just concatenate '01-' with the month and the year selected
from dual?
<ramsey84_at_my-deja.com> wrote in message news: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:52:38 CDT
