Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Differences between two time expresions
Message
 
 
À
12/09/2002 11:36:34
Héctor Lizarraga
Gobierno Del Edo de Querétaro
Querétaro, Mexique
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00699743
Message ID:
00699802
Vues:
15
Try
lcTime2 = '09:25:16'
lcTime1 = '09:02:45'
lnSeconds = CTOT(lcTime2) - CTOT(lcTime1)
? TRANSFORM(RIGHT(TTOC( DTOT(DATE()) + lnSeconds,1),6), "@R 99:99:99")
It will work as long as lnSeconds < 86400. If lnSeconds >= 86400 see Re: Datetime variation in HH:MM:SS Message #698240.

>What I want is to substract them and convert that result in minutes\seconds format.
>
>I've tried this (CTOT('09:25:16') - CTOT('09:02:45'))/60) but in the most cases the result is a fraction that I don´t know hopw to convert to seconds.
>
>Any idea?
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform