vidhya sagar (10/28/2007)
You can convert current date as you required by below piece of code
You can change the last variable value from 101 to 121 and each value represent one datetime format
Thanks for the reply, but you may have missed the point of the question.
How do I get "Microsoft SQL Server Manager Studio Express" to display "datetime" variables in the format of my choice.
Ideally for any database and any table I use the application for.
One would assume that there was a Preference settting somewhere to control how the application displays a "datetime" variable. ???
However, if you have given me the answer, I must admit I am a SQL novice, and therefore do not know how to apply your answer to the "Studio Express" application.