[rt-users] RT email time

Kevin Falcone falcone at bestpractical.com
Wed Jun 9 15:02:10 EDT 2010


On Wed, Jun 09, 2010 at 12:08:04PM -0400, Juan N. DLC wrote:
>    OK, so what will be the best approach to resolve my issue?

I still don't know what your issue is.  If your issue is that RT is
storing dates in the database in UTC then you really don't have an
approach other than 'rewrite RT'

-kevin

>    On Wed, Jun 9, 2010 at 11:53 AM, Kevin Falcone <[1]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][2]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][3]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][4]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][5]http://rtbook.bestpractical.com
>      >
>      > References
>      >
>      > Visible links
>      > 1. mailto:[6]falcone at bestpractical.com
>      > 2. mailto:[7]jmoseley at corp.xanadoo.com
>      > 3. mailto:[8]juann.dlc at gmail.com
>      > 4. [9]http://rtbook.bestpractical.com/
>      >
>      > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>      > Buy a copy at [10]http://rtbook.bestpractical.com
> 
>      Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>      Buy a copy at [11]http://rtbook.bestpractical.com
> 
> References
> 
>    Visible links
>    1. mailto:falcone at bestpractical.com
>    2. mailto:falcone at bestpractical.com
>    3. mailto:jmoseley at corp.xanadoo.com
>    4. mailto:juann.dlc at gmail.com
>    5. http://rtbook.bestpractical.com/
>    6. mailto:falcone at bestpractical.com
>    7. mailto:jmoseley at corp.xanadoo.com
>    8. mailto:juann.dlc at gmail.com
>    9. http://rtbook.bestpractical.com/
>   10. http://rtbook.bestpractical.com/
>   11. 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/917c58b9/attachment.sig>


More information about the rt-users mailing list