On Saturday 27 October 2007 06:04:00 Richard Detwiler wrote: > [EMAIL PROTECTED] wrote: > > On Friday 26 October 2007 13:31:18 Joe Smith wrote: > >> NoOp wrote: > >>> ... > >>> http://www.openoffice.org/issues/show_bug.cgi?id=76623 > >> > >> However, I found the description of the cause of the problem > >> troubling: how can time zone calculations interfere with the > >> entry of a date? > >> > >> As far as I can tell, Calc does not do any conversion of the > >> date (or time) as entered--all date/time values in Calc are > >> stored and displayed as local time. > >> > >> So why is the time zone setting triggering these effects? > >> > >> Maybe I misunderstood the developer's explanation. > > > > Most apps that use the date or time use both because 21:03 is > > not as specific as 21:03 05/12/06 The former is the exact > > minute of the day of any day, any month, any year, but the > > later is the exact minute of the day on a specific day, month > > and year. There is a more technically correct way to say this. > > I will leave that to someone else. > > That makes sense, but I'm not sure it explains the situation that > led to the original post. That was a case of someone just > entering a simple date, not a date and a time. If one enters a > date alone, does a time somehow get tacked onto it, but not > displayed? To me, that wouldn't make a lot of sense. Or is there > something I'm missing?
Joe explained it. Basically date and time is really the same thing. The date/time on the computer is is set/watched/stamped based on a date/time from a starting point in the distant past (I think around 1900 or earlier for *nix and later for Windows). Going back to the earlier example 21:03 marks a point in time that is every 24 hours and can be past, present and future. Adding the date then says the time stamp is only for one time period at that minute and not all of them past, present and future. In the world we have dates and time for recording the movement of something from a starting point. We use time on a daily interval without realizing that the time we are talking about isn't just 15:00 but it is 15:00 at 10/27/2007 UTC or 15:00 at 10/27/2007 UTC-* which is different from UTC. with the computer this short cut that every one is used to using is ignored and recorded completely. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
