[rt-users] RT email time

[Kenneth Marshall]

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.
> 
> On Thu, Jun 3, 2010 at 11:46 AM, James Moseley <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 <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.
> >>
> >>

You should be able to set the time_zone for your MySQL database
when it starts and/or the database connection. Then you will be able
to retrieve/set the correct values. (Not a MySQL expert.)

Cheers,
Ken