Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Time display
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01574527
Message ID:
01574540
Views:
63
This message has been marked as a message which has helped to the initial question of the thread.
>Hi everybody,
>
>I am wondering how can I display datetime value using
>
>mm/dd/yyyy hh:mm:ss format where hours are in 24 format? Using transform(datetime()) returns date with AM/PM settings. Also, I may want to display it just up to hh:mm (no seconds).
>
>Any ideas?
>
>Thanks in advance.
? TRANSFORM(DATETIME())
lnHours=SET("Hours")
lcSeconds=SET("Seconds")
lcDate=SET("Date")
lcCentury=SET("Century")
SET SECONDS OFF
SET HOURS TO 24
SET CENTURY ON
SET DATE AMERICAN
? TRANSFORM(DATETIME())
SET HOURS TO lnHours
SET SECONDS &lcSeconds.
SET DATE &lcDate.
SET CENTURY &lcCentury.
? TRANSFORM(DATETIME())
Frank Camp
Previous
Reply
Map
View

Click here to load this message in the networking platform