Re: timestamp mysql oddity
Re: timestamp mysql oddity
- Subject: Re: timestamp mysql oddity
- From: Johann Werner <email@hidden>
- Date: Sun, 17 Aug 2008 01:40:18 +0200
Looking at wikipedia it says BST = British Summer Time UTC+1h which
means that your system time is (correctly) set to your local timezone
in London. The default time zone for MySQL is your system time zone so
it will save timestamps accordingly. In your first post you noted that
a timestamp gets incremented by one hour. Your example had a timestamp
that was GMT so converting it to BST results in adding one hour. (I
assume that the year 22009 was a typo)
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 30000
And 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 with
ALTER 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.
Alan
On 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 that
you 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 (email@hidden
)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-
email@hidden)
Help/Unsubscribe/Update your Subscription:
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
-----------------------------------------------------
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.
-----------------------------------------------------
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
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