Re: timestamp mysql oddity
Re: timestamp mysql oddity
- Subject: Re: timestamp mysql oddity
- From: Johann Werner <email@hidden>
- Date: Sat, 16 Aug 2008 18:39:26 +0200
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:
This email sent to email@hidden
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
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