Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TIME from DATETIME()
Message
De
23/06/2005 13:16:15
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01025859
Message ID:
01025937
Vues:
14
>>>Hey Gurus....
>>>
>>>My mind is slipping in my old age.
>>>
>>>What is an easy(?) way to get the TIME component out of a DATETIME value (store the TIME part to a string variable)?
>>
>>There's no easy way, at least before VFP9.
>>
ltDt = DATETIME()
>>* VFP8
>>? TRANSFORM( RIGHT( TTOC(ltDt,1), 6), "@R 99:99:99")
>>* VFP9
>>? RIGHT( TTOC(ltDt,3), 8)
>>
>
>You think MS would've included a simple function to extract the time...!!!!

If you want the current time:
? TIME()
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform