If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

With kind regards . . . . . SQL Server 2000/2005/2012
Wim
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

SQL Server has no control over how dates are displayed on your screen so this isn't a SQL Server question. You must configure your client application or presentation tier to display dates in the format you want. For example, most Windows applications use the format set in Windows Control Panel.

Why would you do that? As I already said, you just need configure the format in the right place and you'll be fine. We can't tell you how to do it because you didn't tell us what client application or development language you are using, but there's certain to be a straightforward way to change the date format.