Compare Dates in SQL

Compare Dates in SQL

With Between
CAST(CONVERT (varchar,@FromDate,101) AS DATE) between CAST(CONVERT (varchar,DateFrom,101) AS DATE) and CAST(CONVERT (varchar,DateTo,101) AS DATE)

With Operator
CAST(Convert(varchar,DateOfJoining,101) AS DATE) > CAST(CONVERT (varchar,@FromDate,101) AS DATE)