Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select drops leading ZERO in TTOC(datetime,2)
Message
 
To
03/08/1999 16:30:19
Dore Svei
Olympia, Washington, United States
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Re: SQL Select drops leading ZERO in TTOC(datetime,2)
Miscellaneous
Thread ID:
00249398
Message ID:
00249426
Views:
15
Dore,

That PADL(,5) doesn't work. I had already tried that, for some reason.

Try it with SET SYSFORMATS ON and have your Regional Settings in Control Panel set to:

h:mm:ss tt

It won't override that setting.

You Got Me!
Rich Simpson
Arnold, MO
Mind's Eye, Inc.

Mind's Eye Report Engine Page
Previous
Reply
Map
View

Click here to load this message in the networking platform