Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dealing with time field
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01282322
Message ID:
01282350
Views:
9
>>>Thank you
>>>Can you imagine any formula do apply if the time_out is past
>>>midnight ?
>>
>>That is why I would use DateTime. Because you will have date part also.
>>
>>lnDateStart = DATETIME(2008,1, 7, 12, 30,0) && 2008/01/07 :12:30:00 (yyyy/mm/dd hh:mm:ss)
>>lnDateEnd   = DATETIME()                    && Hmm, it is differen always when you run it :-)
>>
>>? lnDateEnd - lnDateStart && Difference in seconds
>>? (lnDateEnd - lnDateStart)/3600 && Difference in minutes
>>
>
>In minutes? <g>
>
>Just joking. You will do a lot in 3600 sec. in a minute.

Grrrr,
In hours :-)
? (lnDateEnd - lnDateStart)/60 && Difference in minutes
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