- Operator (minus) subtracts two numbers or a number (in days) from date.
Example
1. Subtracts values from 2 numeric columns
create table #test(value int, fee int)
insert into #test(value, fee) values (500,50),(100,10)
select
value - fee as 'diff'
from
#test
drop table #test
Result
diff
450
90
2. Subtracts from date
SELECT getdate() - 1 AS 'Subtract Date';
