Try this, hope this will be easy and simple way

--Try option 1

declare @days as int

set @days = 4

declare @dts as datetime

set @dts = GETDATE()

select name, birth_date

from <table name>

where (

...