sqllodar date format urgent

[babjee]

Hi all

I export / save my Ms access table to .csv file. For a date field it is storing data like 30-11-01 0:00:00.

In oracle loader control file I am using format as date “dd-mm-yy hh:mm:ss” . result of this command it is not loading any record into my table pls help me


Regards
babjee

[oravijay]

Hi,

Try to give like this:

field1 DATE 'dd-mon-yy'


HTH.

Thanks.
Vijay.

[Horace]

Try dd-mm-yy hh:mi:ss
instead of
dd-mm-yy hh:mm:ss

[Tarry]

Originally posted by babjee
Hi all

“dd-mm-yy hh:mm:ss” .
Regards
babjee

This is really the most commonly made mistake.The correct is....
[B] dd-mm-yy hh:mi:ss [B]

Then u won't forget it, I hope.

Cheers!!

[Tarry]

Originally posted by babjee
Hi all

“dd-mm-yy hh:mm:ss” .
Regards
babjee

This is really the most commonly made mistake.The correct is....
dd-mm-yy hh:mi:ss

Then u won't forget it, I hope.

Cheers!!

[Horace]

Looks like Tarry's got poor eyesight !!
I posted the correct format without the bells and whistles, and only the once !! And without the patronising font

[Tarry]

I like bell's and whistles!

[babjee]

HI ALL

It d'nt works. I user this format "dd-mm-yy hh24:mi:ss"
it is working fine. thank u for ur sugessions

regards
babjee