Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dealing with time field
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01282322
Message ID:
01282350
Vues:
10
>>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform