[rt-users] RT email time

[Juan N. DLC]

OK, so what will be the best approach to resolve my issue?

On Wed, Jun 9, 2010 at 11:53 AM, Kevin Falcone <falcone at bestpractical.com>wrote:

> On Wed, Jun 09, 2010 at 11:31:28AM -0400, Juan N. DLC wrote:
> >    For correction, I'm not trying to tdo queries to my RT DB, my problem
> is that for some reason
> >    between RT and MySQL is a time_zone problem. my RT GUI have the
> correct time/date but MySQL is
> >    using UTC time, 4 hours ahead the real time.
>
> RT stores dates in MySQL in UTC.  It then converts on display.
>
> -kevin
>
> >    On Wed, Jun 9, 2010 at 10:57 AM, Kevin Falcone <[1]
> falcone at bestpractical.com> wrote:
> >
> >      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][2]
> 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][3]
> 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.
> >
> >      Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> >      Buy a copy at [4]http://rtbook.bestpractical.com
> >
> > References
> >
> >    Visible links
> >    1. mailto:falcone at bestpractical.com
> >    2. mailto:jmoseley at corp.xanadoo.com
> >    3. mailto:juann.dlc at gmail.com
> >    4. http://rtbook.bestpractical.com/
>
> >
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com
>
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100609/35ca98dc/attachment.htm>