Re: Oracle date format

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Sun, 07 Nov 2004 22:02:28 +0100
Message-ID: <cmje6t$9np$1_at_news6.zwoll1.ov.home.nl>

Bill wrote:
> 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".

Hm - too bad you don't post the name, too. It looks like a timestamp format; the XFF represents the fractional seconds part of the timestamp.
>
> 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
>>
>>

>
>
>

Is it possible to inject *any* SQL? Like 'alter session set nls_date_format='DDMMYYYY HH24:MI:SS' ???

-- 

Regards,
Frank van Bortel

Received on Sun Nov 07 2004 - 22:02:28 CET