[rt-users] RT email time

[Kevin Falcone]

On Wed, Jun 09, 2010 at 09:01:34AM -0400, Juan N. DLC wrote:
>    So then, there is no way to change this? other than move my server local time 4 hours behind
>    the real time? That would affect the RT GUI too.

Juan

As James correctly stated, RT stores dates in the database in GMT and
converts them for display in the UI.  If you want to pull data
directly from the DB, you will have to do your own conversion.
If you are pulling from the API or the UI and getting the wrong date
then that would be interesting.

-kevin

>    On Thu, Jun 3, 2010 at 11:46 AM, James Moseley <[1]jmoseley at corp.xanadoo.com> wrote:
> 
>      I believe RT, by design, uses the UTC timestamp when storing data in the database.
> 
>      --
>      James
> 
>      On Thu, Jun 3, 2010 at 10:19 AM, Juan N. DLC <[2]juann.dlc at gmail.com> wrote:
> 
>        Yes, I do have the TZ configured in my RT_SiteConfig.pm
> 
>        # Time Zone:
>        Set($Timezone , 'America/Puerto_Rico');
> 
>        LIke I said, the GUI time is working fine, the problem is MySQL, when creating a ticket it
>        set the Creation Time 4 hours after the real time.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100609/a1a68d38/attachment.sig>