Re: Display of DATE format in Management Studio

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

maybe its 08 only, not sure. but according to the docs it should do it.

"Aaron Bertrand" <moc.liamg@xxxxxxxxxxxxxx> wrote in message news:C6F260DB.2591C%moc.liamg@xxxxxxxxxxxxxxxxx
I'm not sure how SET DATEFORMAT helps.


SET DATEFORMAT DMY;
SELECT GETDATE();
SET DATEFORMAT MDY;
SELECT GETDATE();


results:


-----------------------
2009-10-07 15:14:17.917


-----------------------
2009-10-07 15:14:17.917




On 10/7/09 2:50 PM, in article
8DA8B249-355A-40C3-9DC6-0693AC7C77A8@xxxxxxxxxxxxx, "Justin Rich"
<jrich523@xxxxxxxxxx> wrote:

http://msdn.microsoft.com/en-us/library/ms189491.aspx

"shil" <joshilat@xxxxxxxxx> wrote in message
news:55e20148-7291-48f0-964c-ce5107bcde86@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi all,

When I execute a SQL query to display values from a table, the date
format is being displayed as "2009-06-07 00:00:00". But I would like
it to display as "6/7/2009 12:00:00 AM".
Is there any setting in the Management Studio I need to set?
My laptop's Language is set to "English (United States)" in the
Regional and Language Settings.

Thanks.



.

Relevant Pages

  • Re: Display of DATE format in Management Studio
    ... I'm not sure how SET DATEFORMAT helps. ... When I execute a SQL query to display values from a table, ... Regional and Language Settings. ...
    (microsoft.public.sqlserver.programming)
  • Re: dateformat is ignored
    ... > and put it in the database using the cursor. ... > a "set dateformat dmy" before running the INSERT statement. ... Use the CONVERT function with the style parameter to ...
    (comp.databases.ms-sqlserver)
  • RE: Sql Server Date problems
    ... "SET DATEFORMAT dmy" should make it so that you don't have to use an ... unambiguous date format in the SELECT statement. ... is overriding the SET DATEFORMAT. ... > AMB ...
    (microsoft.public.sqlserver.programming)