Ankit Sudhera Portfolio Website

Programming is my Passion
Provide Training is my skill
Quality and Commitment is my Life's Goal
Quality and Commitment is my Life's Goal
Programming is my Passion
Provide Training is my skill
Quality and Commitment is my Life's Goal
Quality and Commitment is my Life's Goal
Twitter Linkedin-in Facebook Skype Whatsapp
Programming and Support is my Quality
Programming and Support is my Quality
Programming and Support is my Quality
Twitter Linkedin-in Facebook Skype
Menu
Menu

Forum

Forums
Windows
MS Office
Convert CSV date fo...
 
Notifications
Clear all

Convert CSV date format into MySQL date format in Excel

 
MS Office
Last Post by Sonia Sudhera 2 years ago
1 Posts
1 Users
0 Reactions
415 Views
RSS
 Sonia Sudhera
(@sonia31khurmi)
Member Admin
Joined: 3 years ago
Posts: 3
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.


   
Quote
Topic Tags
Convert CSV date format i Convert CSV date to MySQ
Forum Jump:
  Previous Topic
Topic Tags:  Convert CSV date format i (1) , Convert CSV date to MySQ (1) ,
Share: