Closed Thread
Results 1 to 3 of 3

Thread: MySQL TimeStamp date incorrect: Dec 31, 1969

  1. #1
    bocharwood is offline x10Hosting Member bocharwood is an unknown quantity at this point
    Join Date
    Mar 2010
    Posts
    2

    MySQL TimeStamp date incorrect: Dec 31, 1969

    Hi,

    I'm using CURRENT_TIMESTAMP in my SQL database.

    when echoing the date, it returns:
    Dec 31, 1969

    Is this something I can change to fix this? Or is this a problem to do with the servers.

    Regards,
    Josh Harwood
    Last edited by bocharwood; 03-06-2011 at 04:03 PM.

  2. #2
    descalzo's Avatar
    descalzo is offline Grim Squeaker descalzo has a brilliant futuredescalzo has a brilliant futuredescalzo has a brilliant future
    Join Date
    Jul 2009
    Location
    Ankh-Morpork
    Posts
    7,635

    Re: MySQL TimeStamp date incorrect: Dec 31, 1969

    Why did you make a timestamp column auto-increment?

    Auto-increment starts at 1 and goes up one each time. It is not a time/date field.
    Nothing is always absolutely so.

  3. #3
    bocharwood is offline x10Hosting Member bocharwood is an unknown quantity at this point
    Join Date
    Mar 2010
    Posts
    2

    Re: MySQL TimeStamp date incorrect: Dec 31, 1969

    My bad,

    It's not a Auto_Increment.

    Question still stands though,

Closed Thread

Similar Threads

  1. Hacked. How to view file timestamp?
    By bl01x in forum Free Hosting
    Replies: 1
    Last Post: 11-27-2010, 07:03 PM
  2. Timestamp Reporting Incorrect Time?
    By localkey in forum Free Hosting
    Replies: 0
    Last Post: 03-01-2010, 08:03 PM
  3. El 29 de octubre de 1969 nació Internet…
    By detodoseries in forum General
    Replies: 10
    Last Post: 11-03-2009, 12:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers