OK, so what will be the best approach to resolve my issue? On Wed, Jun 9, 2010 at 11:53 AM, Kevin Falcone <[email protected]>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] > [email protected]> 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] > [email protected]> 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] > [email protected]> 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:[email protected] > > 2. mailto:[email protected] > > 3. mailto:[email protected] > > 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 >
Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
