mycow Posted February 20, 2009 Share Posted February 20, 2009 Hello I have the following LOAD DATA INFILE 'c:\\file.csv' INTO TABLE file_input FIELDS TERMINATED BY ';' ENCLOSED BY '"' IGNORE 2 LINES (col1, col2, col3, col4, col5, col6, col7, col8, @col9, @col10, @col11, col12, col13, col14, col15, col16, col17, col18, col19, col20) set col9 = str_to_date(@col9, '%d-%m-%Y'), col10 = str_to_date(@col10, '%d-%m-%Y'), col11 = str_to_date(@col11, '%d-%m-%Y') ; My problem is that col9 col10 and col11 are datetime and don't know how to fix the syntax to include time. Can anyone help? Thank you Quote Link to comment Share on other sites More sharing options...
mycow Posted February 20, 2009 Author Share Posted February 20, 2009 Found the solution %d-%m-%Y %H:%i:%s Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.