I have a query wrt comparing two datetime values.
i have a query:
Select Count(1) Records From tblA
Where Convert(Varchar(10),Row_Insert_Date,103) <= Convert(Varchar(10),GetDate(),103)
I have few doubts regarding this:
1. Should we / Should'nt we use Convert. Explanation will be greatly appreciated.
2. What is the best way to compare dates.