Re: timestamp mysql oddity
Re: timestamp mysql oddity
- Subject: Re: timestamp mysql oddity
- From: Alan Ward <email@hidden>
- Date: Sat, 16 Aug 2008 10:48:58 -0600
Looks to me like those dates are 20,000 years apart though, not just
1 hour ;-)
Alan
On Aug 16, 2008, at 10:39 AM, Johann Werner wrote:
Hi Gino,
this timeshift happens if you have different time zone settings for
your app and the database. It is commonly suggested to use GMT for
both and convert the timestamp to the correct time zone when
displaying it on a page to a user.
jw
Am 16.08.2008 um 18:30 schrieb Gino Pacitti:
Hi All
Can anyone shed any light on why a timestamp:
2009-08-22 23:59:59 Etc/GMT
becomes
22009-08-23 00:59:59 in the database
When it is saved?
Seems like an hour is added by the database to a formatted
NSTimestamp..
I have Mysql 4.1.22 and WO 5.3.3
Thanks in advance...
Gino
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40isd.uni-stuttgart.de
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40apple.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden