JohnCampbell
Joined: 16 Feb 2006
Posts: 2615
Location: Sydney
|
 Posted: Wed Oct 12, 2011 1:36 am Post subject: Date_and_Time for daylight saving |
 |
|
This may be a note only, but I have tested DATE_AND_TIME and it reports the standard time zone, without any daylight saving modification.
For Sydney today with daylight saving, where the local time is 11 hours ahead of UTC/GMT, VALUES(4) is reported as 600.
I looked at the time zone in task bar and it reports "(GMT+10:00)" but selects automatically adjust for daylight saving changes.
However, Values(5) is reporting the correct local hour for daylight saving time.
I notice on the forum web site that before I log in, local time is reported with daylight saving time still in place for Grenwich (?) but reports my local time as GMT+10hr after I log in, which is out by 1 hour.
I'm not sure how Windows XP implements daylight savings.
Should VALUES(4) = 660 (current local minutes agead of UTC/GMT) be the expected result or has XP fudged the time for daylight savings ?
The relevance of this is that FILES@ reports the dos_date and dos_time wrt UTC, which needs to be corrected to local time (potentially with the daylight savings adjustment at the time the file was last modified !!)
John |
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
