Date Conversion in SQL

Question

1.00/5 (1 vote)

See more:

Hey guys i need your help.

How do i convert date in this format mm/dd/yyyy to yyyy-mm-dd in sql server

Thanks for your help

Posted 7-Nov-13 5:23am

rudolph098

Updated 2-Apr-20 2:05am

Add a Solution

Comments

Richard MacCutchan 7-Nov-13 11:48am

Don't store dates as strings in your database. Use proper DateTime types to store as absolute values.

4 solutions

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)

ZurdoDev · Answer 1 · 2013-11-07T05:28:00

Solution 1

http://msdn.microsoft.com/en-us/library/ms187928.aspx[^]

This explains the different numbers you can use to create various formats; however, you may want to rethink doing date formatting in SQL. I would recommend doing the formatting in whatever program you are doing.

Posted 7-Nov-13 5:28am

ZurdoDev

coded007 · Answer 2 · 2013-11-08T18:37:00

Solution 2

SQL

Select CAST('2013-10-08' as date)

Posted 8-Nov-13 18:37pm

coded007

Niraj K Verma · Answer 3 · 2020-04-02T00:01:00

Solution 5

Select Format(Convert(date,ColumnName),'yyyy-mm-dd') from Table_Name

Posted 2-Apr-20 0:01am

Niraj K Verma

Comments

Richard Deeming 2-Apr-20 8:42am

The Format function was introduced in SQL Server 2016, which was released almost three years after this question was posted.

And as already mentioned, this is a UI concern, not a database concern. Formatting should not be done in the database.

ishan_shah · Answer 4 · 2020-04-02T02:07:00

Solution 6

Hi,
Simply you should convert your format into date data-type using the CONVERT(). Following is an example of the same.

Example:

SQL

Select convert(date,getdate())

Posted 2-Apr-20 2:07am

ishan_shah

Comments

Richard Deeming 2-Apr-20 8:43am

This is essentially the same as solution 2, which was posted back in 2013.

ishan_shah 3-Apr-20 1:27am

Yes but just a little difference in the function used by both of us. He/She has used CAST() and I am using CONVERT().