default date format of sql server 2008 to dd/mm/yyyy

Question

1.00/5 (1 vote)

See more:

SQL

please help,
how to change the default date format of sql server 2008 to dd/mm/yyyy format

thanks in advance

Posted 29-May-12 4:34am

b3nz33r

Add a Solution

10 solutions

Solution 2

just changed language to britan english
object Explorer=> security=> logins=>(user)=>Default language= Britan english

Posted 29-May-12 6:36am

b3nz33r

Comments

Nelek 29-May-12 17:38pm

That might solve it for now, but it is not a consistant solution. I would recommend you to have a look to the links Sandeep gave you.

Solution 6

EXEC sp_configure 'default language', '23';
go
RECONFIGURE
GO

Posted 27-Nov-12 22:22pm

Aadhar Joshi

Solution 3

It,s very simple just write the following query to get the default date in dd/mm/yyyy.

select convert(varchar,convert(datetime,getdate(),105),103).

Hope this help you thanks.

Posted 29-May-12 8:10am

shivammpi123

Solution 4

using the convert method you can do it easily. Run the Follwing Query.
SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY]

Posted 5-Sep-12 1:42am

sangeethamanikandan

Updated 5-Sep-12 1:48am

v2

Comments

Davidduraisamy 8-Mar-13 4:02am

he is asking about default dateformat...so this is correct---- SET DATEFORMAT dmy;

Solution 8

SET DATEFORMAT mdy

CHECK USING

DBCC UserOptions

Posted 7-Mar-13 0:25am

Davidduraisamy

Solution 9

SQL

SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [MM/DD/YY]

Posted 7-Mar-13 22:00pm

P.S Vijay

Solution 10

SELECT convert(varchar,getdate(),103)

This query will solve your problem....

Posted 8-Dec-13 18:20pm

Jain Nishant

Solution 11

if you want to change default sql date format into dd/MM/yyyy

use
SELECT convert(varchar(10),getdate(),103)

or you can get any date format if you have default sql date format

URL: SQL Server Functions that helps to convert date and time values to and from string literals and other date and time formats.[^]

Posted 19-Jun-14 22:13pm

_Kapil

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ganesh Nikam · Accepted Answer · 2012-09-05T01:58:00

Solution 5

hiii

just Execute Commands as below

SET DATEFORMAT dmy;

to see changes
dbcc useroptions

Posted 5-Sep-12 1:58am

Ganesh Nikam

Sandeep Mewara · Accepted Answer · 2012-05-29T04:48:00

Solution 1

Have a look here: MSDN Blogs: How to change Date Format after installing SQL server[^]

Alternatively, you can use: MSDN: SET DATEFORMAT (Transact-SQL)[^]

Posted 29-May-12 4:48am

Sandeep Mewara

Comments

Maciej Los 29-May-12 12:39pm

Great! My 5!

Sandeep Mewara 29-May-12 14:12pm

Thanks.