Home Forums SQL Server 2005 SQL Server Express Microsoft SQL Server Management Studio Express - datetime RE: Microsoft SQL Server Management Studio Express - datetime

  • October 29, 2007 at 8:54 am

    #746274

    vidhya sagar (10/28/2007)

    [font="Courier New"]You can convert current date as you required by below piece of code

    select convert(varchar(25),getdate(),101)

    You can change the last variable value from 101 to 121 and each value represent one datetime format[/font]

    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. 🙂