Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting TIME() to a readable format
Message
 
 
To
21/09/2008 13:23:14
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01349313
Message ID:
01349314
Views:
23
>Is there a cleaner/better way of converting a time() to a more readable format?
>
>m.DisplayTime = RIGHT(TRANSFORM(CTOT(TRANSFORM(TIME(),'@R 99999999'))),11)
>
The TIME() is pretty readable. What exactly do you want to change? What format do you want time to be presented in ?
On my PC your expression returns the same as TIME() prefixed with '99 ' - '99 13:28:00'
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform