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

AI Assistant
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 ankitbnl406 3 years ago
1 Posts
1 Users
0 Reactions
1,407 Views
RSS
 ankitbnl406
(@ankitbnl406)
Member Admin
Joined: 4 years ago
Posts: 13
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
16/05/2023 11:30 am   [#6]
  • 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: