add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table mytable (
startdate datetime not null,
noofdays int not null,
enddate as dateadd(day, noofdays, startdate)
)
insert into mytable (startdate, noofdays) values(getdate(), 3);
1 rows affected
select * from mytable;
startdate noofdays enddate
2020-12-12 01:40:16.903 3 2020-12-15 01:40:16.903