Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Display Century in SQL Browse
Message
From
28/06/1999 13:25:09
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:
00234845
Views:
24
>>>>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.

I FINALLY got it. This occurs in the Regional Settings dialogue.

Thanks, Bob
Database Development Team
Previous
Reply
Map
View

Click here to load this message in the networking platform