Update Date

Ramco Ramco

I have below value in Database . It is DateTime field. Database is Sql. I want to add 2 weeks in Date , other values remain same.

2023-04-01 15:15:00.000

Thanks

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar3y ago
Accepted answer
Hello Ramco,

below one is correct, if you are using .AddDays() method it will not change time. it only adds days, beloow one only adds number of weeks which you have selected from dropdown
```
Rec.SessionDate = Convert.ToDateTime(Rec.SDate).AddDays(7*Convert.ToInt32(ddlWeeks.SelectedValue));
```
Ramco Ramco3y ago
Hi

How to do in c#. I want chane only Date Time Values should remain same.

Thanks

Rajkiran Swain3y ago

To add 2 weeks to a date in SQL Server, you can use the DATEADD function. Here is an example query that adds 2 weeks to the date 2023-04-01 15:15:00.000:


SELECT DATEADD(week, 2, '2023-04-01 15:15:00.000')
This will return the date 2023-04-15 15:15:00.000.

If you want to update the value in the database to reflect the new date, you can use an UPDATE statement:


UPDATE MyTable
SET MyDateColumn = DATEADD(week, 2, MyDateColumn)
WHERE MyPrimaryKeyColumn = 123

This will add 2 weeks to the MyDateColumn value for the row with primary key 123 in MyTable.

Ramco Ramco3y ago
Hi

I am trying below cide. Is it ok

Rec.SessionDate = Convert.ToDateTime(Rec.SDate).AddDays(7*Convert.ToInt32(ddlWeeks.SelectedValue));

I want to change only date. Time should remain same. With above code it is changing tome to 0.

Thanks

Jignesh Kumar3y ago

Hello Ramco,

You can use DateADD() function to do this, please try below,

select DATEADD(WEEK, 2, GETDATE()) -- this will  add 2 week to today's date

declare @id int = 1
update tablename set yourDatefield = DATEADD(WEEK, 2, yourDatefield) where id=@id

-- @id is parameter