Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Day light savings issue
Message
From
08/11/2007 16:19:22
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
08/11/2007 15:14:03
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01267255
Message ID:
01267772
Views:
22
>>>Thinking about this a little more, it's not a trivial problem. You'd need to test if VFP does any compensation already at the time changes.
>>
>>It doesn't. Let's assume the time of your message and a week before that. That should be 7*24+1=169 hours, because we've had the time moved (actually on my machine it was moved manually - because of the bug Windows once had, I've dropped the automatics):
>>
x=DATETIME(2007,11,8,14,14,12)
>>x8=DATETIME(2007,11, 1, 13,45,56)
>>?x8-x
>>?x-x8
>>SET DECIMALS TO 13
>>?(x-x8)/(24*3600)
>>
>>
>>The only adjustment I suspect VFP makes is usage of seconds() over midnight - it was changed at some point to continue counting and not reset to zero. Not sure when does it actually reset - there's zero mention of any change in the Help.
>
>Did you check around the date where the time USED to change i.e. the last Sunday in October?

Yes - just set DATETIME(2007,10,8,14,14,12), and it still gives a round number of days; if I use DATETIME(2007,10,8,15,14,12) (i.e. one hour later), I get 30.9583 days instead of 31.0000. So no, it does not adjust anything on my machine.

Did anyone else test this?

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform