Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Display Century in SQL Browse
Message
 
To
25/06/1999 15:14:46
Robert Byrd
National Association of Homebuilders
Washington, District of Columbia, United States
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00233477
Message ID:
00234141
Views:
30
>>>When I open a table showing all records, my datetime fields display as mm/dd/yy. I need to display them as mm/dd/yyyy.
>>>
>>>I cannot find anything in the documentation for this. Any ideas?
>>>
>>>Thanks,
>>>Bob
>>
>>Did you tried changing your short date setting in the control panel?
>
>I do not see a way to set century display on in the Control Panel. The Date/Time setting only allows me to set the date and time and regional options. So I am not clear on what you are talking about.
>
>Bob

In the "Short date style", manually modify it to be MM/dd/yyyy.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform