Menu
▾
▴
1 Attachments
#92 Jackcess does not correctly manage daylight saving time correctly on the change over date
Jackcess does not manage date correctly on the date when date light saving switching occurs.
i.e. the database file attached contains two dates (without time field) where the second row is the date on which the switching takes place (7/Oct/2012, timezone Australia/Sydney). When this date is read, I got 6/Oct/2012 instead. Since date is specified in local time in MS Access, I would expect to get 7/Oct/2012 instead.
can you provide more details about how you generated this test database? were you running it on a computer where the default timezone is australia, or did you specify that manually?
I took the second date (read using australia timezone and formatted using australia timezone) and looped adding an hour and printing out the result:
date+0: 2012.10.06 23:00:00 EST
date+1: 2012.10.07 00:00:00 EST
date+2: 2012.10.07 01:00:00 EST
date+3: 2012.10.07 03:00:00 EST
date+4: 2012.10.07 04:00:00 EST
date+5: 2012.10.07 05:00:00 EST
it looks like the time in the access db is a few hours before the time change (you can see the jump at +3).
have you tried viewing the database in ms access on a computer in the australia timezone?
Hi James,
Thanks for turning this around within a short time. Are you expecting to make 1.2.9 available any time soon, otherwise I will download the source and try to compile it.
Regards.
Sent from my HTC
----- Reply message -----
From: "James Ahlborn" jahlborn@users.sf.net
To: "[jackcess:bugs] " 92@bugs.jackcess.p.re.sf.net
Subject: [jackcess:bugs] #92 Jackcess does not correctly manage daylight saving time correctly on the change over date
Date: Mon, Oct 15, 2012 14:48
status: open --> closed
milestone: v1.0_(example) --> 1.2.9
bugs:92 Jackcess does not correctly manage daylight saving time correctly on the change over date
Status: closed
Created: Mon Oct 08, 2012 06:18 AM UTC by David Chen
Last Updated: Sat Oct 13, 2012 12:37 AM UTC
Owner: nobody
Jackcess does not manage date correctly on the date when date light saving switching occurs. i.e. the database file attached contains two dates (without time field) where the second row is the date on which the switching takes place (7/Oct/2012, timezone Australia/Sydney). When this date is read, I got 6/Oct/2012 instead. Since date is specified in local time in MS Access, I would expect to get 7/Oct/2012 instead.
Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/jackcess/bugs/92/
To unsubscribe from further messages, please visit https://sourceforge.net/auth/prefs/
you caught the tail end of the release cycle. 1.2.9 went out last night.
Thanks for the reply. Speaking of good timing.
I will grab the new library and test it in my app to confirm too in the morning.
Kind Regards
David
From: James Ahlborn jahlborn@users.sf.net
To: [jackcess:bugs] 92@bugs.jackcess.p.re.sf.net
Sent: Tuesday, 16 October 2012, 23:50
Subject: [jackcess:bugs] #92 Jackcess does not correctly manage daylight saving time correctly on the change over date
you caught the tail end of the release cycle. 1.2.9 went out last night.
bugs:92 Jackcess does not correctly manage daylight saving time correctly on the change over date
Status: closed Created: Mon Oct 08, 2012 06:18 AM UTC by David Chen Last Updated: Mon Oct 15, 2012 03:48 AM UTC Owner: nobody
Jackcess does not manage date correctly on the date when date light saving switching occurs.
i.e. the database file attached contains two dates (without time field) where the second row is the date on which the switching takes place (7/Oct/2012, timezone Australia/Sydney). When this date is read, I got 6/Oct/2012 instead. Since date is specified in local time in MS Access, I would expect to get 7/Oct/2012 instead.
Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/jackcess/bugs/92/
To unsubscribe from further messages, please visit https://sourceforge.net/auth/prefs/