Notifications
Clear all
MS Office
1
Posts
1
Users
0
Reactions
254
Views
Topic starter
16/05/2023 11:30 am
- Open CSV in Excel or Export your MySQL DB as CSV in excel.
- Select the cell containing the date you wish to convert.
- Select "custom" (or "more Number formats") from the format cells dropdown.
- In the type field type Enter "yyyy-mm-dd hh:mm:ss".
- Select the cell, copy it and paste the format to all other cells containing dates.
- Import your CSV into MySQL.
If you like this article please share or add a link to your site, Blog, Facebook page, Twitter or any online page. Thank you.