Hi All,
We have an application where we load data on a daily basis and then do some
analysis and the move this data into different tables.

Data is comming in files. The date format in the file is "dd-mon-yyyy
hh24:mi:ss', but as you all know, in mysql , the default date format is
"yyyy-mm-dd hh24:mi:ss". How can i specifiy this format in the load data
infile script.

I tried this

LOAD DATA LOCAL INFILE 'abc.txt' INTO TABLE abc FIELDS TERMINATED BY ','
LINES TERMINATED BY '^V\n' (doj timestamp "dd-mon-yyyy hh24:mi:ss");

but data is not getting inserted.

Please help me.

regards
anandkl