Return dates between number of days

Question

I wonder how I do:

I want a variable like days

then take the result of this variable and select between the dates counting the number of days

Some solution or example?

Answer 1

I don’t quite understand, but if you want to make a trial, try it this way.

declare @primeira_data datetime, @segunda_data datetime, @result int;
set @result:= Day(@primeira_data) - Day(@segunda_data);

There is a function that does this for you

DATEDIFF ( datepart , startdate , enddate )  

https://docs.microsoft.com/pt-br/sql/t-sql/functions/datediff-transact-sql?view=sql-server-2017