Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Unanswered: UNIX_TIMESTAMP() has 1 hour delay

    i am working on a server that time had set to local time.
    when i type "SELECT UNIX_TIMESTAMP(),curdate();" , the curtime shows the right local time, but unix_timestamp shows 1 hour delay in GMT time.
    i think something on the server set false.
    anyone can help?

  2. #2
    Join Date
    Jan 2009
    I think UNIX_TIMESTAMP will return negative numbers for some
    times in timezones with a positive offset from GMT

    so you can use

    timezone = America/Los_Angeles
    Last edited by alexsqlforums; 07-16-09 at 16:08.

Posting Permissions

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