Re: Oracle date format

[Quoted] 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.
>
>
Received on Thu Nov 04 2004 - 19:14:28 CET