Displaying items by tag: ms excel

    Subscribe to this RSS feed
    Wednesday, 03 August 2016 10:14

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

    How to convert a 10 Digit Number (or Unix Timestamp) into a date in excell

    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

    Published in Microsoft Excel
    Read more...