If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Windows "date modified" and daylight savings time
"bucky3" wrote in message ... On Nov 2, 9:21 am, bucky3 wrote: So before DST, if I had a file modified at 14:00 UTC, and my timezone was PDT(-7), then Windows file explorer would display the time stamp as 7:00, which was correct. But now that it is DST, which is PST(-8), Windows is displaying the time stamp as 6:00, which is incorrect. Correction: So *DURING* DST, if I had a file modified at 14:00 UTC, and my timezone was PDT(-7), then Windows file explorer would display the time stamp as 7:00, which was correct. But now that it is *NO LONGER* DST, which is PST(-8), Windows is displaying the time stamp as 6:00, which is incorrect. Why is it incorrect? The file was modified at a fixed time, to which is either added or not an hour. 06:00 normal time = 07:00 summer time. 14:00 - 8 hours = 06:00. If you always want "wall-clock" time displayed for files, store then on a FAT-16 file system. Possibly even a FAT-32 volume, but I haven't checked that. Cheers, David |
#2
|
|||
|
|||
Windows "date modified" and daylight savings time
David J Taylor wrote:
"bucky3" wrote in message ... On Nov 2, 9:21 am, bucky3 wrote: So before DST, if I had a file modified at 14:00 UTC, and my timezone was PDT(-7), then Windows file explorer would display the time stamp as 7:00, which was correct. But now that it is DST, which is PST(-8), Windows is displaying the time stamp as 6:00, which is incorrect. Correction: So *DURING* DST, if I had a file modified at 14:00 UTC, and my timezone was PDT(-7), then Windows file explorer would display the time stamp as 7:00, which was correct. But now that it is *NO LONGER* DST, which is PST(-8), Windows is displaying the time stamp as 6:00, which is incorrect. Why is it incorrect? The file was modified at a fixed time, to which is either added or not an hour. 06:00 normal time = 07:00 summer time. 14:00 - 8 hours = 06:00. You're both wrong :-) When going DST, you don't change timezones. You stay in the same timezone, but apply DST. In this time zone, June 21st, 12:00 is the way to denote a specific moment in time(*), and there is only one way to denote a specific moment in that time zone. If you went to lunch at 12:00 on that day, you aren't going to tell you went to lunch at 11:00 if you tell a story about it later in winter (unless it's used as an alibi and you are trying to fool a detective). So if a file has a June 21st 12:00 timestamp, the computer should always display it as June 21st 12:00 as long as it is set up in that time zone, whether DST applies or not. Of course, if the computer is configured in the next timezone, then the same timestamp can be displayed as June 21st, 11:00, and this will be the correct display in summer and winter in that time zone. So yes, Windows is broken (http://www.peterdonis.net/computers/computersarticle3.html), but what's new? (*) except for the "duplicate hour" that happens during the fallback night, -- Bertrand |
#3
|
|||
|
|||
Windows "date modified" and daylight savings time
"Ofnuts" wrote in message
... [] So if a file has a June 21st 12:00 timestamp, the computer should always display it as June 21st 12:00 as long as it is set up in that time zone, whether DST applies or not. Of course, if the computer is configured in the next timezone, then the same timestamp can be displayed as June 21st, 11:00, and this will be the correct display in summer and winter in that time zone. [] Bertrand Yes, I can see your argument, but if you take it to its logical conclusion, wouldn't you need to include the different time zone of the taking device in your calculation of displayed date as well as the time zone of the display device, so pictures taken at the same instant would show a different timestamp if they were taken in New York, London or Paris? Cheers, David |
#4
|
|||
|
|||
Windows "date modified" and daylight savings time
David J Taylor wrote:
"Ofnuts" wrote in message ... [] So if a file has a June 21st 12:00 timestamp, the computer should always display it as June 21st 12:00 as long as it is set up in that time zone, whether DST applies or not. Of course, if the computer is configured in the next timezone, then the same timestamp can be displayed as June 21st, 11:00, and this will be the correct display in summer and winter in that time zone. [] Bertrand Yes, I can see your argument, but if you take it to its logical conclusion, wouldn't you need to include the different time zone of the taking device in your calculation of displayed date as well as the time zone of the display device, so pictures taken at the same instant would show a different timestamp if they were taken in New York, London or Paris? A timestamp is absolute. In computers it is stored as the number of seconds (or milliseconds, or nanoseconds) since a reference time (00:00 UTC on January 1st, 1970 for Unix and a lot of web-related things)(*). Whether it is later displayed as June 21st, 12:00 or June 21st, 09:00 depends only on the "reader". In other words the timezone is nothing more than a parameter when displaying or parsing date representations, and unless it is implicit (but with computers, "implicit" is seldom a good idea) it should be part of the display or input string. Giving a time as "2009/11/03 12:00" without a time zone is a bit like giving an appointment at 12:00 but not telling which day. So, ideally, your three cameras would attach the very same time stamp to the three photos. However, the people who did the Exif standard overlooked the timezone/DST problem. The timestamp is stored as a "YYYY:MMD HH:MM:SS" character string, and doesn't include a time zone. So this information is lost and if the three cameras above are on local time, they will store a different timestamp string. If the standard had provided for a time zone, they would have stored something like "2009/11/03 12:00 UTC+0" in London, "2009/11/03 13:00 UTC+1" in Paris, and "2009/11/03 07:00 UTC-5" in NY which are three different representations of the very same timestamp. And the cherry on the cake is that the FAT/FAT32 file system used in memory cards uses local time, and files are often transferred between camera and computer using a card reader, so unless the camera is carefully kept on local time things can get quite fun later, for instance when geotagging the pictures. (*) see "epoch" on Wikipedia -- Bertrand |
#5
|
|||
|
|||
Windows "date modified" and daylight savings time
"Ofnuts" wrote in message ... [] A timestamp is absolute. In computers it is stored as the number of seconds (or milliseconds, or nanoseconds) since a reference time (00:00 UTC on January 1st, 1970 for Unix and a lot of web-related things)(*). ... conveniently forgetting about things like leap seconds, perhaps? Whether it is later displayed as June 21st, 12:00 or June 21st, 09:00 depends only on the "reader". In other words the timezone is nothing more than a parameter when displaying or parsing date representations, and unless it is implicit (but with computers, "implicit" is seldom a good idea) it should be part of the display or input string. Agreed. Giving a time as "2009/11/03 12:00" without a time zone is a bit like giving an appointment at 12:00 but not telling which day. So, ideally, your three cameras would attach the very same time stamp to the three photos. That would depend how the users have the cameras set, of course. However, the people who did the Exif standard overlooked the timezone/DST problem. The timestamp is stored as a "YYYY:MMD HH:MM:SS" character string, and doesn't include a time zone. So this information is lost and if the three cameras above are on local time, they will store a different timestamp string. If the standard had provided for a time zone, they would have stored something like "2009/11/03 12:00 UTC+0" in London, "2009/11/03 13:00 UTC+1" in Paris, and "2009/11/03 07:00 UTC-5" in NY which are three different representations of the very same timestamp. ... and once lost, it's gone forever. And the cherry on the cake is that the FAT/FAT32 file system used in memory cards uses local time, and files are often transferred between camera and computer using a card reader, so unless the camera is carefully kept on local time things can get quite fun later, for instance when geotagging the pictures. (*) see "epoch" on Wikipedia -- Bertrand It can also be fun if: - you take pictures before the time-change, and upload them to your computer afterwards. - you take pictures in one time-zone and upload them in another and I'm sure you can think of even more circumstances. For those reasons, I keep my camera set to UTC rather than local time, and I don't change it between summer and winter. I don't bother about leap seconds on the camera, as its clock isn't accurate enough to warrant it. It is an important point to know that Windows displays the time with the actual date, and the current offset time, rather than the time offset for the taking date. Cheers, David |
#6
|
|||
|
|||
Windows "date modified" and daylight savings time
David J Taylor wrote:
"Ofnuts" wrote in message ... [] A timestamp is absolute. In computers it is stored as the number of seconds (or milliseconds, or nanoseconds) since a reference time (00:00 UTC on January 1st, 1970 for Unix and a lot of web-related things)(*). .. conveniently forgetting about things like leap seconds, perhaps? No, they are taken in account (assuming the display and parsing code are correct (mostly the display, since most serious computers self-synchronize via NTP). Whether it is later displayed as June 21st, 12:00 or June 21st, 09:00 depends only on the "reader". In other words the timezone is nothing more than a parameter when displaying or parsing date representations, and unless it is implicit (but with computers, "implicit" is seldom a good idea) it should be part of the display or input string. Agreed. Giving a time as "2009/11/03 12:00" without a time zone is a bit like giving an appointment at 12:00 but not telling which day. So, ideally, your three cameras would attach the very same time stamp to the three photos. That would depend how the users have the cameras set, of course. This assumes that the cameras would have a way to know the "absolute" time (ie, set to UTC, or given a timezone). It is an important point to know that Windows displays the time with the actual date, and the current offset time, rather than the time offset for the taking date. Not even sure of the date part. If a file is stamped at 00:30 on June 21st, will Window show it later as stamped at 23:30 on June 21st or at 23:30 on June 20th? -- Bertrand |
#7
|
|||
|
|||
Windows "date modified" and daylight savings time
Ofnuts wrote:
David J Taylor wrote: "Ofnuts" wrote in message ... [] A timestamp is absolute. In computers it is stored as the number of seconds (or milliseconds, or nanoseconds) since a reference time (00:00 UTC on January 1st, 1970 for Unix and a lot of web-related things)(*). .. conveniently forgetting about things like leap seconds, perhaps? No, they are taken in account (assuming the display and parsing code are correct (mostly the display, since most serious computers self-synchronize via NTP). Whether it is later displayed as June 21st, 12:00 or June 21st, 09:00 depends only on the "reader". In other words the timezone is nothing more than a parameter when displaying or parsing date representations, and unless it is implicit (but with computers, "implicit" is seldom a good idea) it should be part of the display or input string. Agreed. Giving a time as "2009/11/03 12:00" without a time zone is a bit like giving an appointment at 12:00 but not telling which day. So, ideally, your three cameras would attach the very same time stamp to the three photos. That would depend how the users have the cameras set, of course. This assumes that the cameras would have a way to know the "absolute" time (ie, set to UTC, or given a timezone). It is an important point to know that Windows displays the time with the actual date, and the current offset time, rather than the time offset for the taking date. Not even sure of the date part. If a file is stamped at 00:30 on June 21st, will Window show it later as stamped at 23:30 on June 21st or at 23:30 on June 20th? There is no easy universal way around these problems. Fortunately in the grand scheme of things it's not a big deal as long as you are aware of what's happening. If one is that picky, set the camera to UTC, keep it that way and just do a mental adjustment as needed. |
#8
|
|||
|
|||
Windows "date modified" and daylight savings time
On Tue, 3 Nov 2009 20:57:14 +0000 (UTC), Toxic
wrote: On Tue, 03 Nov 2009 13:56:43 +0000, David J Taylor wrote: I keep my camera set to UTC rather than local time Good idea, and since I've got to go in and dither its clock one of these days, I think I'll do likewise. My camera (Nikon D300) is set to synchronise time with my computer every time I connect the two. The computer (Windows XP) shows local time, including the adjustment for DST. It also is synchronised daily with a time signal from somewhere (USN Hawaii?) All of this is very convenient and much more meaningful than me having to maintain my camera at UTC. Eric Stevens |
#9
|
|||
|
|||
Windows "date modified" and daylight savings time
On 2009-11-03 13:25:30 -0800, bucky3 said:
Thanks everyone, that was quite an educational thread. Just curious, how do other operating systems (like Unix, Mac) handle the file timestamp in regards to DST? Do they have the same problem, or do they handle it better? Apple provides an option for automatic date & time setting via one of 3 online time servers; Apple Americas/U.S. (time.apple.com); Apple Asia (time.asia.apple.com); Apple Europe (time.euro.apple.com) this automatically handles all DST issues. -- Regards, Savageduck |
#10
|
|||
|
|||
Windows "date modified" and daylight savings time
In article 2009110313342154666-savageduck1@REMOVESPAMmecom,
Savageduck wrote: Just curious, how do other operating systems (like Unix, Mac) handle the file timestamp in regards to DST? Do they have the same problem, or do they handle it better? Apple provides an option for automatic date & time setting via one of 3 online time servers; Apple Americas/U.S. (time.apple.com); Apple Asia (time.asia.apple.com); Apple Europe (time.euro.apple.com) this automatically handles all DST issues. other time servers can be added and the time stamp is utc with a time zone offset. |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"Corset-Boi" Bob "Lionel Lauer" Larter has grown a "pair" and returned to AUK................ | \The Great One\ | Digital Photography | 0 | July 14th 09 12:04 AM |
BLOG "19 Simple Ways To Get Fantastic Travel Savings" | Bart | Photographing Nature | 0 | November 20th 07 02:43 AM |
Oly 5050 Z internal "battery" no longer holds date and time | Frank H | Digital Photography | 2 | May 7th 07 05:51 PM |
preventing "auto focus" (automatically comming to the fore/background) between multiple windows in PS (CS2)? | [email protected] | Digital Photography | 1 | December 20th 06 11:03 AM |
How to insert the "modified time" attribute in "date taken" attrib in batch mode | ashjas | Digital Photography | 4 | November 8th 06 09:00 PM |