Re: Oracle date format
Date: Thu, 4 Nov 2004 14:30:52 -0600
Message-ID: <cme3hs$u9$1_at_news.sap-ag.de>
[Quoted] HI all,
By using: "SELECT name,value$ FROM sys.props$;"
I was able to get the format as "DD-MON-RR HH.MI.SSXFF AM".
[Quoted] Does anyone know what XFF represents?
I tried: '01-NOV-04 10:29:50000 AM', but still received an error.
"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
>
>
Received on Thu Nov 04 2004 - 21:30:52 CET