Re: First day date of a month

K Stahl wrote:
>
> Sybrand Bakker wrote:
> >
> > select to_char(trunc(sysdate,'YYYY-MM'))
> > from dual;
> >
> > Sorry to correct an employee of Oracle.
> >
> > >
>
> That causes the error:
>
> ORA-01898: too many precision specifiers

trunc(date,'MM')

Cheers

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse