Re: First day date of a month
From: K Stahl <BlueSax_at_Unforgettable.com>
Date: Wed, 23 Feb 2000 13:44:49 -0500
Message-ID: <38B42AA1.45E8A569_at_Unforgettable.com>
Date: Wed, 23 Feb 2000 13:44:49 -0500
Message-ID: <38B42AA1.45E8A569_at_Unforgettable.com>
Connor McDonald wrote:
>
> 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')
>
There is no such thing as just 'date'. That must be a function that someone created on your system. Received on Wed Feb 23 2000 - 19:44:49 CET