Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TIME from DATETIME()
Message
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:
01025908
Views:
12
>>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...!!!!

Thanks, Sergey
Tommy Tillman A+ NetWork+ MCP
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform