Walter Meester
HoogkarspelPays-Bas
Information générale
Titre:
Day light savings issue
Versions des environnements
All,
A client called about an incorrect calculation of the time (hrs) between two events. I was calculating the time by using ROUND(DateTime2 - DateTime1)/3600,0). However this does not take into account change of time because of daylight savings.
I'm aware that Windows does store the date and time somewhere on which the daylight saving time change happens. It needs to pick it up from the regional settings as the software is running in many different countries, with and without daylight savings.
Is there an easy way of calcutating the number of hours between two events and taking day light savings into account.
BTW, I need to do this in VFP and SQL ...
Thanks in advance,
Walter,
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement