RT (Request Tracker) Date Handling

[David Dick]

this sounds like a GMT vs Aus EST time issue..... aren't we 11 hours in 
front at the moment?

Scott Penrose wrote:

>Hey Dudes.
>
>I am doing some manual quereis on an RT database and having problems with the dates and times.
>
>In an RT Ticket we have a Last Updated time of "Fri Nov  7 12:14:06 2003".
>
>If I do a query on the database I get the following:
>
>mysql> select LastUpdated, UNIX_TIMESTAMP(LastUpdated) as uts from Tickets where id = 12511;
>+---------------------+------------+
>| LastUpdated         | uts        |
>+---------------------+------------+
>| 2003-11-07 01:14:06 | 1068128046 |
>+---------------------+------------+
>1 row in set (0.00 sec)
>
>If I convert the unix time stamp there to a local time I get:
>
>scottp at lust:505:~$ localtime 1068128046
>Fri Nov  7 01:14:06 2003
>
>Note that they are the same, all 1:14 (AM).
>Note that RT shows this is actually 12:14 pm (11 hours later).
>
>I can only conclude one of two possible issues.
>
> * RT is removing 11 hours before storing in the database - thus invalid entries are being stored in the database.
>
>OR
>
> * MySQL is not correctly returning Unix Time Stamps
>
>Does anyone know which is likely ? And how to fix it ?
>
>Scott
>---
>Scott Penrose
>Digital Dimensions
>scott at dd.com.au
>http://www.dd.com.au/
>
>
>  
>