Subject: [rt-users] Date/Time in exported spreadsheet wrong

[Bjoern Schulz]

Hi Andrew,
yes, it is GMT. Jesse gave the hint some day ago. But I haven't got an 
idea to fix it.

cheers, Björn

Andrew Dike schrieb:
> Hi Bjoern,
> 
> I have noticed the same issue in RT 3.6.0. I'm not sure if I got to the
> bottom of it but I believe that the time recorded in the database is always
> GMT. When you view times and dates via the web front end, the settings in
> RT_SiteConfig.pm come into effect, adjusting the time for your location.
> However the export function always outputs data direct from the DB.
> 
> I hope there's a straightforward way to fix this because it's quite
> frustrating for users.
> 
> 
> 
> Andrew
> 
> Date: Tue, 02 Oct 2007 09:18:39 +0200
>> From: Bjoern Schulz <bjoern.schulz at desy.de>
>> Subject: [rt-users] Date/Time in exported spreadsheet wrong
>>
>>
>> Hi list,
>>
>> we are using RT 3.6.5 RC2 and I observe the following problem.
>> We like to export search data to a spreadsheet, but there is a different
>> between the date in the web-UI and the exported data. In our case its 2
>> hours.
>>
>>
>> Our RT_SiteConfig.pm
>> # $Timezone is used to convert times entered by users into GMT and back
>> again
>> # It should be set to a timezone recognized by your local unix box.
>> Set($Timezone , 'Europe/Berlin');
>>
>>
>>
>> Thanks for any input!
>>
>> bjoern
>>
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com