RT (Request Tracker) Date Handling

[Aaron Wigley]

On Fri, Nov 07, 2003 at 02:30:26PM +1000, Scott Penrose wrote:
> 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.

I would guess that RT is using gmtime, not localtime.  At the moment
we are 11 hours different to UTC.

Wigs