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

[Andrew Dike]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20071009/36ae6887/attachment.htm>