How to format dateadd SQLServer?

Question

0.00/5 (No votes)

See more:

Hi everybody, I'm try.

SQL

select dateadd(day, 30, '2014-09-01') as EXPDATE

but it display like this

SQL

2014-10-01 00:00:00.000

I just want like this

SQL

2014-10-01

Thank you for answer.

Posted 2-Oct-14 8:02am

terzasek

Add a Solution

2 solutions

Solution 1

What is being returned is a date, the display of which depends on how you format it for viewing.

You can use FORMAT but it will give you a string as a result not a date type : http://www.w3schools.com/sql/sql_func_format.asp[^]

Posted 2-Oct-14 8:11am

Mehdi Gholam

Comments

terzasek 2-Oct-14 14:42pm

Thank you very much. ^ ^ :D

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)

Richard Deeming · Accepted Answer · 2014-10-02T08:23:00

Solution 2

The string is being converted to a datetime type by default. Try explicitly converting it to a date first:

SQL

select dateadd(day, 30, CAST('2014-09-01' as date)) as EXPDATE

Posted 2-Oct-14 8:23am

Richard Deeming

Comments

terzasek 2-Oct-14 14:42pm

Wow! Very nice Thank you.