Re: Oracle date format

"Bill" <bill_at_tadi.com> wrote in message news:cmdri7$pmo$1_at_news.sap-ag.de...
> Unfortunately, this is not a class.
>
> Any suggestions?
>
> "Alan" <alan_at_erols.com> wrote in message
> news:2uv9nmF2eo0a0U1_at_uni-berlin.de...
> >
> > "Bill Li" <bill_at_tadi.com> wrote in message
> > news:cmdr02$pdk$1_at_news.sap-ag.de...
> > > Hi all,
> > > I am trying to insert date/time value into a column with datatype
date.
> > > During this insertion, I cannot use to_date or any other Oracle
> functions.
> > >
> > > When I use the string, '01-jan-2004', the value is inserted okay.
> > However,
> > > when I included the time, e.g. '01-jan-2004 01:01:01', I get the error
> > > ORA-01830 (date format picture ends before converting entire input
> > string).
> > >
> > > Does anyone know what is the native string value I can use to when
> insert
> > > into a date datatype?
> > >
> > > Thanks,
> > > Bill
> > >
> > >
> >
> > Perhaps this is what your instructor wanted you to see.
> >
> >
>
>
Did you read the docs on the to_date function? Never ever, use implicit string to date conversion, use to_date and specify the date format. Jim Received on Fri Nov 05 2004 - 02:50:57 CET