Re: ORA-01830

From: Irfan Baig <irfan_at_abstractedge.com>
Date: Fri, 27 Jul 2001 19:04:36 GMT
Message-ID: <20010727.145958.1782436840.31262@irf.local>

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
>
>
>
Received on Fri Jul 27 2001 - 14:04:36 CDT