How to convert date formate into nvarchar in SQL 2005

Question

0.00/5 (No votes)

See more:

i have lot of data in different different date sql table. i have date is in date time format like 2016-04-31 00:00:00.000 and i want convert this date on nvarchar format like 31-04-2016.I am using sql 2005 and 2008.

thank
with regards
Praveen

What I have tried:

i have lot of data in sql table. i have date is in date time format like 2016-04-31 00:00:00.000 and i want convert this date on nvarchar format like 31-04-2016.I am using sql 2005 and 2008.

thank
with regards
Praveen

Posted 3-Aug-16 23:06pm

Member 10554297

Updated 4-Aug-16 3:12am

Add a Solution

Comments

Richard MacCutchan 4-Aug-16 5:51am

That is the wrong way to do it. You should always store date values as Date or DateTime types. The only time you need to format them is when you wish to display them on screen or report.

2 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)

Maciej Los · Answer 1 · 2016-08-04T03:12:00

Solution 2

MSDN documentation states that you can use:
CAST and CONVERT (Transact-SQL)[^]
or
FORMAT (Transact-SQL)[^]

Note: this is not recommended, unless you want to convert it only for display purposes!

Posted 4-Aug-16 3:12am

Maciej Los

Comments

Richard Deeming 4-Aug-16 11:47am

FORMAT was introduced in SQL 2012. It probably won't work in SQL 2005! :)

Maciej Los 4-Aug-16 11:51am

You're right. I missed that.

Bikesh Srivastav · Answer 2 · 2016-08-03T23:09:00

Solution 1

You can found your solution here visit it.
SQL Server CONVERT() Function[^]

Posted 3-Aug-16 23:09pm

Bikesh Srivastav