Post reply

Formatting date columns within the 2005 server

  • January 7, 2010 at 5:39 am

    #138067

    Hi,

    Firstly, I hope I have posted this in the correct forum.

    We have several SQL 2005 servers installed. Unfortunately, on some servers 'date' fields are displayed as dd/mm/yyyy whereas they are set as mm/dd/yyyy on other servers. This is obviously annoying for readability of (dashboard type) reports within SQL Server Management Studio and displayed values in DATE columns (i.e. SmallDateTime datatype) when opening SQL tables. I would prefer to have all set to dd/mm/yyyy.

    Is this a setting on install? If so, can we amend those without re-installing? Otherwise, how can we alter the current settings for the instances of mm/dd/yyyy date columns?

    Thanks in advance,

    Neal

  • January 7, 2010 at 6:01 am

    #1100136

    If you query a table directly, it should always display a datetime column in the following format: 2009-01-13 00:00:00.000.

    Could you please provide some samples where you see that behaviour?

    One reason might be different language setting of server, login or session. Or different style values for CONVERT() in the queries.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply