Re: ORA-01830

It depends...

The client's registry setting will override any other if the client has any NLS_ parameter defined there; if NLS_DATE_FORMAT is not set, but any other nLS_ parameter is then the format will be the default for the version of Oracle you are using - I think it is MM-DD-YY

If you have NLS_DATE_FORMAT set in your client registry, change it to the format you want...

If no NLS_ parameters are set on the client, then you can set the NLS_DATE_FORMAT in the init<servicename or sid>.ora file

Remember, no matter what NLS_DATE_FORMAT is used, or where it is set, the actual value in the DATE field is exactly the same, this parameter only affects the display and interpretation of the data ..

"Irfan Baig" <irfan_at_abstractedge.com> wrote:

>Thanks - unfortunately I have thousands of records to load, which were
>generated in the same way. The easier solutiuon would be to change my
>default date format - how can this be done, if possible ?
>
>> Your default date format is DD-MON-YYYY. For any other format you will
>> need the to_date function in this case
>> to_date('28-SEP-2000 13:04:14','dd-mon-yyyy hh24:mi:ss')
>>
>> I would recommend to use a to_date function *always*.
>>
>>
>> Hth,
>>
>> Sybrand Bakker, Senior Oracle DBA
>>
>>
>>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Fri Jul 27 2001 - 14:50:14 CDT