Re: timestamp mysql oddity
Re: timestamp mysql oddity
- Subject: Re: timestamp mysql oddity
- From: Gino Pacitti <email@hidden>
- Date: Sat, 16 Aug 2008 17:54:37 +0100
But is this a BST thing and will it change with the clocks move back?
On 16 Aug 2008, at 17:48, Alan Ward wrote:
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
-----------------------------------------------------
Gino L. Pacitti Base Enterprise UK
email: email@hidden
phone: sales: 0845 094 9784
mob: 07980 851 953
Aol: kris121
Msn: email@hidden
Skype: ginkris
Mac.com: email@hidden
http://www.base-enterprise.co.uk
mail: Base Enterprise
PO BOX 674
East Grinstead
West Sussex
RH19 3ZG
Base Enterprise LTD
Company Number 04339224
Registered in England & Wales
Registered Member of the UK Web Design Association.
Accredited by Business Link and a member of the FSB.
Web Design, coding and information architect
Web Objects and Database Developer
HTML, XML, Javascript and WAP technologies.
-----------------------------------------------------
This email and any attachments is confidential and may be legally
privileged and protected from disclosure. It is intended solely for
the use of the individual or entity to whom it is addressed and
others authorized to receive it.
If you are not the intended recipient of this e-mail of any parts of
it please telephone +44 845 094 9784 immediately upon receipt
or contact email@hidden
No other person is authorized to copy, forward or disclose,
distribute or retain this e-mail in any form.
_______________________________________________
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