[rt-users] RT email time

[Kevin Falcone]

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

-------------- 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/66d14e50/attachment.sig>