Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting TIME() to a readable format
Message
From
21/09/2008 14:09:02
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:
01349320
Views:
21
>>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'

Mine returns:
14:03:13
I need:
02:03:13 PM
I'm sure it's due to the environmental settings, but that's what they are set to.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform