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 Link to comment https://forums.phpfreaks.com/topic/146081-solved-load-data-and-datetime/ 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 Link to comment https://forums.phpfreaks.com/topic/146081-solved-load-data-and-datetime/#findComment-766908 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.