jw
Am 16.08.2008 um 19:26 schrieb Gino Pacitti:
Well I am in the UK and the System clock is using Apples European servers for auto setting.The TIMEZONE is London but it seems to be BST This is a print out from the Run log[2008-08-16 18:21:21 BST] <main> Creating LifebeatThread now with: Letinsurance 55555 localhost/127.0.0.1 1085 30000And that seems to indicate a BST TIMEZONE On 16 Aug 2008, at 18:21, Alan Ward wrote:On Aug 16, 2008, at 11:10 AM, Gino Pacitti wrote:So is possible to set the TIMEZONE for the database?Yes. I don't know what database you are using but Oracle has a DBTIMEZONE which can be set withALTER database SET TIME_ZONE = 'GMT'; -- for example and queried with select DBTIMEZONE from dual;In fact, in Oracle columns can have their own timezone overriding the DBTIMEZONE but I wouldn't recommend that.The development app and database are on the same machine yet seem to shift... So it must be that the database is defaulting to UTC rather than GMT.Or some other pair that can be 1 hour apart.... I can't speculate without knowing you location.Would that be the solution then??Yes. AlanOn 16 Aug 2008, at 18:07, Alan Ward wrote:Sounds to me like exactly what Johann described. BST is not really relevant (aside from potentially making the difference 2 hours [or 0 hours] for a couple of weeks a year), but what is relevant is thatyou get the timezones to match between app server and database. Alan On Aug 16, 2008, at 10: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 (Webobjects-dev@lists.apple.com )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 (Webobjects- [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 legallyprivileged and protected from disclosure. It is intended solely forthe 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 ofit 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 (Webobjects-dev@lists.apple.com) 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.----------------------------------------------------- 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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/werner%40isd.uni-stuttgart.de This email sent to [EMAIL PROTECTED]
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]