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 - 15:02:28 CST
