SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Sep 2010
    Posts
    112
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Populating mysql table with date data from a text file & preserving correctnes ofdate

    Hello guys,

    Please do me a favour and suggest the way forward on this.

    I have a php script which extracts data into text files. One of the fields in this text file is date in the format below: How can I preserve the correctness of the date to conform with the mysql default format. I am doing massive import of data from the text file and mysql is truncating the date like.

    Please your opinion would be appreciated

    193138.000,070610,
    182605.000,190810,
    051953.000,200810,
    174651.000,210810,
    140341.000,120610,
    150441.000,130610,
    131631.000,100610,
    125717.000,110610,
    144634.000,080610,
    182417.000,050710,
    142139.000,070710,


    Thanks

    Paul

  2. #2
    Utopia, Inc. silver trophy
    ScallioXTX's Avatar
    Join Date
    Aug 2008
    Location
    The Netherlands
    Posts
    9,033
    Mentioned
    152 Post(s)
    Tagged
    2 Thread(s)
    Question already asked here: http://www.sitepoint.com/forums/showthread.php?t=703782

    Thread closed.
    Rémon - Hosting Advisor

    Minimal Bookmarks Tree
    My Google Chrome extension: browsing bookmarks made easy


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •