Re: First day of the month?

In article <3B3B1A15.572594BD_at_cgi.ca>, stephen.bell_at_cgi.ca says...
>Hi Doug,
>
>What about
>
>SQL> select last_day(sysdate)+1 from dual;
>
>LAST_DAY(
>---------
>01-JUL-01
Hey;

That's the first of next month; I'm looking for the first of this month. I think Spencer's "select trun(sysdate,'MONTH') from dual" wins.

Thanks for the response though.

Doug

-- 
-------------------
Douglas K. O'Leary
Senior System Administrator
dkoleary_at_mediaone.net