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