SQL experts in Oka question

[jefferson1]

oka table lo two columns unnai : CreationDate/Due Date

 

 

 

[jefferson1]

Creation Date                                         DueDate

2020-05-07 21:59:03.787           2020-05-08 21:59:03.787

2020-05-07 21:43:13.787           2020-05-08 21:43:13.787          

2020-05-07 21:29:19.703           2021-05-08 21:29:19.703

 

how do i update the year in due date ( first two rows)

 

there are several rows, which i want the year to be updated

[Sarvapindi]

You wont get right answer if u cant explain ur qn  properly..

[kevinUsa]

5 minutes ago, jefferson1 said:

Creation Date                                         DueDate

2020-05-07 21:59:03.787           2020-05-08 21:59:03.787

2020-05-07 21:43:13.787           2020-05-08 21:43:13.787          

2020-05-07 21:29:19.703           2021-05-08 21:29:19.703

 

how do i update the year in due date ( first two rows)

 

there are several rows, which i want the year to be updated

Use the primary key and alter table change date 

 

[jefferson1]

1 minute ago, Sarvapindi said:

You wont get right answer if u cant explain ur qn  properly..

where did i go wrong?

[VinPetrol]

update  TABLE_name
set duedate =   dateadd( year, 1, duedate )
where year (duedate) = 2020

[jefferson1]

Just now, kevinUsa said:

Use the primary key and alter table change date 

 

got it bro,

thank you

[Biskot2]

9 minutes ago, jefferson1 said:

Creation Date                                         DueDate

2020-05-07 21:59:03.787           2020-05-08 21:59:03.787

2020-05-07 21:43:13.787           2020-05-08 21:43:13.787          

2020-05-07 21:29:19.703           2021-05-08 21:29:19.703

 

how do i update the year in due date ( first two rows)

 

there are several rows, which i want the year to be updated

https://stackoverflow.com/questions/10388351/how-to-change-only-the-year-of-a-date-datatype

[Sarvapindi]

Just now, jefferson1 said:

where did i go wrong?

Nee scenario complete ga explain chey man..ila table undhi..first 2 rows update cheyyali ante ela?.... requirement proper ga cheppu...otherwise the solutions u get now will work but screwup later..