Hi,

I am trying to load a flat file with "Feb 20 2012 12:00:00:000AM" as the date format using nzload from the command prompt.

Following are the options I have chosen to load the date columns.

-dateStyle MONDY

-dateDelim ' '

-timeStyle 12HOUR

-timeDelim ':'

-timeRoundNanos

I am getting the following error when I am trying load it.

bad #: input row #(byte offset to last char examined) [field #, declaration] diagnostic, "text consumed"[last char examined]
----------------------------------------------------------------------------------------------------------------------------
1: 1(20) [1, TIMESTAMP] expected AM or PM, "Feb 20 2012 12:00:00"[:]

So -timeDelim value I have passed is not identifying the ":" before the milliseconds. Is there any alternative to load this using nzload?

Target column is defined as TIMESTAMP.

Appreciate your time and help.

Thanks