Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Minutes between 2 dates
Message
From
25/03/2016 13:15:33
Lutz Scheffler (Online)
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
25/03/2016 13:11:56
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01633746
Message ID:
01633759
Views:
51
>>>>Anyone know of an easy way to calculate the number of minutes between 2 dates. I am trying to store the elapsed time between 2 events
>>>>
>>>>Thanks
>>>>
>>>>Colin
>>>
>>>If you have 2 datetime values, the difference will be in seconds and you can divide by 60 to get the minutes.
>>>
>>>If you're using 2 date values, the difference will be in dates, and you can multiply by 24*60 to get minutes.
>>
>>Only if the day is 24*60*60 seconds long. It might be different sometimes, to be precise. You also have to check for time zones
>>
>>https://www.youtube.com/watch?v=-5wpm-gesOY
>>
>>:D
>>
>>And. not to forget, DST.
>
>You wouldn't need to worry about that if your timestamps are in Universal Time.

I know. It will still not help to include shift-seconds, but it's a start. Also you loose all the nice build-in VFP functions.

:(

-5wpm-gesOY
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform