Problem with Dates

Hello, I’m using the RT version rt-3.4.1, and I’m having a problem with the
dates of creation for the tickets.

For example, on the web I create a ticket XXX on the 2005-06-08 at 14:00, as
soon as I have added it I click on this issues details, and I check the
created date is the same as the above which is also the system date time.
But when I check the “Created” field for this new issue in the mysql, the
"Created" is as “2005-06-08 13:00…”. So there is a difference in the hour!
Created at 14:00 but added in the mysql database as 13:00, but in the site
it remains as 14:00.

Can you please help me?

Best regards,

Pedro Ponte

smime.p7s (2.97 KB)

Hello, I’m using the RT version rt-3.4.1, and I’m having a problem with the
dates of creation for the tickets.

For example, on the web I create a ticket XXX on the 2005-06-08 at 14:00, as
soon as I have added it I click on this issues details, and I check the
created date is the same as the above which is also the system date time.
But when I check the “Created” field for this new issue in the mysql, the
"Created" is as “2005-06-08 13:00…”. So there is a difference in the hour!
Created at 14:00 but added in the mysql database as 13:00, but in the site
it remains as 14:00…

This looks like a problem with timezones.

Quite probably, your server is set to GMT, which has no knowledge of
Daylight Savings Time, while your browser is set to your local
timezone (which is GMT+1 atm, judging from your email address)

This will cause the difference in times between the database and the website.

Gr,

Nils
Simple guidelines to happiness:
Work like you don’t need the money,
Love like your heart has never been broken and
Dance like no one can see you.

Hello again,

Well I’ved check the date on my server by using the date and the date -u
commands. For example:

“[root@localhost /]# date
Thu Jun 16 14:53:15 WEST 2005
[root@localhost /]# date -u
Thu Jun 16 13:53:17 UTC 2005”

What seems to be the problem?

Pedro Ponte
pponte@netcabo.pt
TVCabo PortugalFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Nils Vogels
Sent: quinta-feira, 9 de Junho de 2005 9:48
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Problem with Dates…

Hello, I’m using the RT version rt-3.4.1, and I’m having a problem with
the
dates of creation for the tickets.

For example, on the web I create a ticket XXX on the 2005-06-08 at 14:00,
as
soon as I have added it I click on this issues details, and I check the
created date is the same as the above which is also the system date time.
But when I check the “Created” field for this new issue in the mysql, the
"Created" is as “2005-06-08 13:00…”. So there is a difference in the
hour!
Created at 14:00 but added in the mysql database as 13:00, but in the site
it remains as 14:00.

This looks like a problem with timezones.

Quite probably, your server is set to GMT, which has no knowledge of
Daylight Savings Time, while your browser is set to your local
timezone (which is GMT+1 atm, judging from your email address)

This will cause the difference in times between the database and the
website.

Gr,

Nils
Simple guidelines to happiness:
Work like you don’t need the money,
Love like your heart has never been broken and
Dance like no one can see you.

smime.p7s (2.97 KB)