Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TIME from DATETIME()
Message
From
23/06/2005 13:16:15
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01025859
Message ID:
01025937
Views:
13
>>>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()
Previous
Reply
Map
View

Click here to load this message in the networking platform