Update Date

Question

Hi 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

Jignesh Kumar · 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 Ramco · Answer

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

Rajkiran Swain · Answer

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 Ramco · Answer

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 Kumar · Answer

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