Q&A for scientists using computers to solve scientific problems
declare @table1 table (Id1 int, description1 varchar(50), dt2 datetime2(0)) declare @table2 table (Id2 int, description2 varchar(50), dt2 datetime2(0)) SELECT DATEADD(mi, 1, SYSDATETIME()); --insert into @table1 --values (1, 'test1', dateadd(mi, -10, getdate()); select * from @table1