Ankit Sudhera Portfolio Website

Programming and Support is my Quality
Programming and Support is my Quality
Programming and Support is my Quality

Forum

Convert CSV date fo...
 
Notifications
Clear all

Convert CSV date format into MySQL date format in Excel

1 Posts
1 Users
0 Reactions
278 Views
(@sonia31khurmi)
Member Admin
Joined: 3 years ago
Posts: 3
Topic starter  
  • 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.


   
Quote