Sql Date Between

SqlDateBetween.sql

declare @startDate nvarchar(10);
declare @endDate nvarchar(10);
declare @daysFromNowToStart Int
declare @daysFromEndToNow Int

set @startDate = '2022-10-01';
set @endDate = '2023-02-10';
set @daysFromNowToStart = DATEDIFF(DAY, GETUTCDATE(), @startDate);
set @daysFromEndToNow = DATEDIFF(DAY, @endDate, GETUTCDATE());

select * from orders where
cast(CreatedDate as date) between @startDate and @endDate

select * from orders where
cast(CreatedDate as date) >= @startDate
and
cast(CreatedDate as date) <= @endDate

select * from orders where
cast(CreatedDate as date) >= DATEADD(dd,@daysFromNowToStart,GETUTCDATE())
and
cast(CreatedDate as date) <= DATEADD(dd,@daysFromEndToNow,GETUTCDATE())