NSTimestamp mapped to DATE for mysql
NSTimestamp mapped to DATE for mysql
- Subject: NSTimestamp mapped to DATE for mysql
- From: John Pollard <email@hidden>
- Date: Wed, 16 Jan 2008 15:53:57 +0000
Hi List,
We have tables with mysql DATE type fields and EO attribute types of
NSTimestamp.
After upgrading mysql from 5.0.18 to 5.0.45, the queries are no longer
matching against dates correctly.
For recent dates the date in the query sent to the database has no
time component, such as: 2008-01-01 00:00:00
But, for dates relating to British Summer Time, they appear in the log
as: 2007-08-01 01:00:00
So a 1 hour shift has been applied to the time in the query for dates
within BST.
Using mysql 5.0.18 this has/is working. With mysql 5.0.45 it no longer
works, the queries relating to BST don't match the dates held on the
datebase (just dates with no time).
I think the cleanest solution would be if the various WO layers (mysql
adaptor?) didn't add any time component to the query, but I would be
very interested in any suggestions for resolving this in any way.
Thanks
John
John Pollard
0208 892 2143
077 4221 0024
_______________________________________________
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