Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Day light savings issue
Message
From
08/11/2007 15:14:03
 
 
To
08/11/2007 14:38:08
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01267255
Message ID:
01267756
Views:
19
>>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?
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform