In North America, they only move an hour. I am not sure how to properly handle 20,000 year shifts. ;-)

GMT does not change with the date.

Chuck

On Aug 16, 2008, at 9:54 AM, Gino Pacitti wrote:

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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/werner%40isd.uni-stuttgart.de

This email sent to [EMAIL PROTECTED]

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/award%40apple.com

This email sent to [EMAIL PROTECTED]


-----------------------------------------------------
Gino L. Pacitti   Base Enterprise UK
email: [EMAIL PROTECTED]
phone:  sales: 0845 094 9784
mob: 07980 851 953

Aol: kris121
Msn: [EMAIL PROTECTED]
Skype: ginkris
Mac.com: [EMAIL PROTECTED]

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 PROTECTED]

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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net

This email sent to [EMAIL PROTECTED]


--
Chuck Hill             Senior Consultant / VP Development

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects






_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to