Results 1 to 2 of 2
  1. #1

    MySql time screw

    Hello Just got new server like 2 weeks ago and after I have set everything and finally started coding i found out that mysql behaves strangly.

    following query was returning screwed time.

    select unix_timestamp(20030528022000);


    while it is suppose to be


    3540s difference

    so I went and reinstalled mysql

    but still that occurs but now it is only


    anyone knows how to fix this particular probelm thx.

  2. #2
    Join Date
    Jan 2003
    Sounds like a timezone problem.

Posting Permissions

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