SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Aug 2009
    Posts
    166
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL - TimeStamp - time is off by 3hrs.

    So its 4:00PM EST. I make a new record into my MySQL database and it says the time is 1PM.

    I tried SELECT Current_TIMESTAMP; -- it displays the current timestamp in military time correctly.

    Why do you think it is wrong in my database table?

    Anything i can do to fix this?

    I have mySQL 5 - latest version.

    Rob

  2. #2
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,580
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    How are you inserting the timestamp? Are you using CURRENT_TIMESTAMP in your query too?


Tags for this Thread

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
  •