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 > <[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 <[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. > >> > >>
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 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
