SQL Loader Datetime

[yenfen]

I'm trying to load a date in SQL Loader
Here is what I have in the file

1/22/1999 12:00AM

How do you do it? I'm using date "mm/dd/yyyy HH24:MM" and it kept failing?

Please help!!

Thank you!!!

 

[lewisp]

Try [tt]'mm/dd/yyyy HH24:MMPM'[/tt]

 

[sem]

I suppose that 24 is redundant:

'mm/dd/yyyy HH:MMPM'

Regards, Dima

 

[kccbb]

Dear all,

I usually use :

MI = mintue
MM = month

According to the previous post, is that

MMPM = minute?