Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Day light savings issue
Message
De
08/11/2007 16:19:22
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
08/11/2007 15:14:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Divers
Thread ID:
01267255
Message ID:
01267772
Vues:
23
>>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform