Hi, i have a few servers running QNX 6.3 with the time set in a custom timezone, for daylight savings time, but for some reason one of this machines returns a distinct unixtime.
Let me put a example:
For server1 (With no problems) the unixtime for ‘2009-04-13 12:00:00’ is 1239624000.
For server2 (the one with problems) the unixtime for the same datetime tag is: 1239627600
3600 seconds more than the other, but it has the same timezone configuration and files, anything is the same!!!
This causes me a lot of trouble because i have an application running and storing datetime data with unixtime format in a mysql database (with the command unix_timestamp()) and then export it to a MS Sql Server machine thant convert the numbers of unixtime to a datetime field and all the data of this machine shows 1 hour more than the others.
Excuse me for the poor english, if there’s any doubt about the text up here please tell me so i can figure a way to explain it better.