Displaying the current year without changing the other values.

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

I wanted to display following date value replacing current year with the next year.

2012-07-01 must be changed to 2013-07-01.

Here year part alone to be changed but not the date and month

Pls I need help

Posted 13-Mar-13 2:55am

Biodude Basava

Updated 13-Mar-13 3:21am

Mike Meinz

v3

Add a Solution

Comments

[no name] 13-Mar-13 8:59am

Help with what? How to get the current year? How to add 1 to the previous year value? How to display the current year? Please improve your question.

Biodude Basava 13-Mar-13 9:07am

2012-07-01 must be changed to 2013-07-01.
Here year part alone to be changed but not the date and month

[no name] 13-Mar-13 9:19am

Okay and? What have you tried? Did you try using the YEAR function? What about DATEPART?

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)

Mike Meinz · Accepted Answer · 2013-03-13T03:19:00

Solution 1

Use DateAdd[^] with year as the Datepart parameter.

DateAdd(year,1,YourDateColumnName)

To change an existing date to the next year while keeping the month and day the same:

UPDATE yourtablename SET quarter_startdate=DATEADD(year,1,quarter_startdate);

Posted 13-Mar-13 3:19am

Mike Meinz

Updated 16-Mar-13 3:53am

v2

Keith Barrow · Accepted Answer · 2013-03-13T03:24:00

Solution 2

If it is display that you want:

SQL

SELECT 
    DateAdd(year,1,TableName.dateColumnName) AS [YearAddedDate]
FROM
   TableName

Obviously you'll need to amend if you want to update the table or add criteria. More obviously you'll need to supply the correct values for the italicised names.

Posted 13-Mar-13 3:24am

Keith Barrow

Comments

Biodude Basava 13-Mar-13 9:29am

hey folks thanks a lot it works perfectly. :)

Keith Barrow 13-Mar-13 9:34am

No problem.

Biodude Basava 13-Mar-13 10:13am

got another question....
year should automatically take the currentyear..??

Keith Barrow 13-Mar-13 10:23am

Can't answer that for you, depends what you want to do.

Biodude Basava 13-Mar-13 10:32am

scenario is like..
i have the column quarter_startdate='2012-07-01'.
now i have to write an update query which takes the current year and month and date are fixed.
????

Mike Meinz 16-Mar-13 9:54am

I updated Solution 1 to show an UPDATE statement that updates an existing DATE Data Type column value to the next year but keeps the month and day the same.