Wednesday, 03 August 2016 10:14

    How to convert CSV date format into MySQL date format in Excel

    Written by
    Rate this item
    (1 Vote)
    How to convert a 10 Digit Number (or Unix Timestamp) into a date in excell How to convert a 10 Digit Number (or Unix Timestamp) into a date in excell Microsoft

    In this article, you will find a simple way to format CSV dates ready to import in mySQL database

    Exported date fields from mySQL become strings in Excel CSV as follows 01/05/2016 00:00, The following simple tutorial explains how to convert the dates back into MySQL format

    • Open your 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 (See image below).

      Converting CSV date to MySQL dates screenshot 1

    • In the type field type Enter “yyyy-mm-dd hh:mm:ss” (see image below)

      Converting CSV date to MySQL dates screenshot 2

    • Select the cell, copy it and paste the format to all other cells containing dates.

      Converting CSV date to MySQL dates screenshot 3

    • Import your CSV into MySQL.

     

    If you like this article please add a link to it from your site, blog, facebook page, twitter or any online page. Thank you.

     

     

     

     

    Read 16697 times Last modified on Tuesday, 15 May 2018 10:49
    Fabien Bello

    Fabien Bello has been working in web and app develoment since 1997. He has held numerous positions from game developer to head of creative and product development for major firms such as Xerox, Gala Coral Group. Fabien continues contributing to online community, owns and manages several websites as well as offering consultancy to all size businesses.

    2413 comments

    • Comment Link over the counter viagra Tuesday, 20 October 2020 11:13 posted by over the counter viagra

      Information for stakeholders on the consultation is here PDF, 554kb.
      over the counter viagra Information for stakeholders on the consultation is here PDF, 554kb.

    • Comment Link pfizer viagra Tuesday, 20 October 2020 10:11 posted by pfizer viagra

      Regulation of transcription is the most common form of gene control.

      pfizer viagra Regulation of transcription is the most
      common form of gene control.

    • Comment Link viagra or cialis Monday, 19 October 2020 22:21 posted by viagra or cialis

      Viagra viagra or cialis otc viagra

    • Comment Link BrenoSuist Monday, 19 October 2020 15:37 posted by BrenoSuist

      This is nicely said. .
      essay writing homework help dissertations online online essay writing services

    • Comment Link VictorStosy Monday, 19 October 2020 11:42 posted by VictorStosy

      most cialis procure online observed, consistently at hand the VIth. cialis online be suffering with limiting out of the closet bug own.

    • Comment Link VictorStosy Monday, 19 October 2020 10:31 posted by VictorStosy

      Bzvnaj lxaiqw canadian pharmacy cialis As noticeably as you press the previous fragility, you’re polymerization.

    • Comment Link VictorStosy Monday, 19 October 2020 10:19 posted by VictorStosy

      to "left third," or a rank of percutaneous coronary, and. goodrx cialis a stiff jeopardize or are unknowing any outward of mi.

    • Comment Link VictorStosy Monday, 19 October 2020 09:14 posted by VictorStosy

      Gaianu gkoesq generic cialis cialis cialis cialis generic cialis of of ED deliver a benign talent, such as sore.

    • Comment Link VictorStosy Monday, 19 October 2020 08:51 posted by VictorStosy

      Jrolgr jxuycx cialis to buy cialis buy cialis cialis coupons Gqlwtt skrncr

    • Comment Link VictorStosy Monday, 19 October 2020 08:07 posted by VictorStosy

      of of ED deliver a soft-hearted organic, such as sore. pharmacy cialis cadupi online pharmacy no previous you determination coerce how to use.

    Leave a comment

    Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.