Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Difference between two time stamps
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01360224
Message ID:
01360246
Views:
8
>>>What is the simplest (or just simple) way of calculating time difference in minutes? For example,
>>>
>>>
>>>*-- Store current Hours and Minutes portion of time
>>>nTime1 = substr(time(),1,5)
>>>*-- Store another time on Hours and Minutes
>>>nTime2 = substr(time(),1,5)
>>>
>>>
>>>Given that both time() reading were done in the same day, what is the difference between nTime2 and nTime1
>>>in minutes? (Note that I cannot use the Seconds() function)
>>>
>>>Thank you in advance for any help.
>>
>>
>>nTime1  = substr(time(),1,5)
>>
>>*** Another time
>>nTime2 = substr(time(),1,5)
>>ltTime1 = DTOT(DATE())+VAL(LEFT(nTime1,2))*3600 + VAL(RIGHT(nTime1,2))*60
>>IF nTime1 > nTime2
>>   ltTime2 = DTOT(DATE()+1)+VAL(LEFT(nTime2,2))*3600 + VAL(RIGHT(nTime2,2))*60
>>ELSE
>>   ltTime2 = DTOT(DATE()+1)+VAL(LEFT(nTime2,2))*3600 + VAL(RIGHT(nTime2,2))*60
>>ENDIF
>>? ltTime2 - ltTime1 && Result in seconds
>>
>
>Thank you. I didn't think of converting to seconds and calculating the difference in seconds and then converting to minutes. I appreciate your help.


Oops,
That should be:
IF nTime1 > nTime2
   ltTime2 = DTOT(DATE()+1)+VAL(LEFT(nTime2,2))*3600 + VAL(RIGHT(nTime2,2))*60
ELSE
   ltTime2 = DTOT(DATE())+VAL(LEFT(nTime2,2))*3600 + VAL(RIGHT(nTime2,2))*60 && Not DATE()+1
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform