Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: date format help
Hi Mark. It looks like i finaly have it working. I needed to specify
COLUMN_NAME and then DATE "YYYY-MM-DD HH24:MI:SS" to SQL loader.
Mark G wrote in message <3785e8d8.0_at_145.227.194.253>...
>Can you post the code which is causing problems?
>
>ed zappulla wrote in message <7m4orl$gfr$1_at_autumn.news.rcn.net>...
>>Ugh! I am having the worst time trying to get a date in and out of Oracle
>>8.0.5. I have set nls_date_format = 'YYYY-MM-DD HH24:MI:SS' in both the
>>dynamic config and a stored config via instanace manager. I've also tried
>>to resarted the data base and selected the stored config. nls_date_format
>>is set as above.
>>
>>I only get the date back from a select when using sqlplus. I have to
still
>>use a to_char() to format it.
>>
>>The real rub is that when I use sqlldr80 I try to set a date column to
>>1999-01-01 07:00:00. I get back an error ORA-01861 literal does not match
>>format string.
>>
>>Also, what is the default format for a date and time. I can store a date
>as
>>1999-JAN-01 but can't add a time to it.
>>
>>Any ideas?
>>
>>...ed
>>
>>
>>
>>
>>
>
>
Received on Fri Jul 09 1999 - 09:40:25 CDT