5 Best Ways to Compare 2 DateTime - [SQL Server]

How to compare two datetime using SQL Server?

This article introduces for comparing two datetime in SQL Server and let’s explores in detail query examples as,

=> BASIC DATE COMPARISON

--USING DATE FORMAT
SELECT * FROM Customer
WHERE CreatedOn > '2016-12-02'

--USING DATETIME FORMAT
SELECT * FROM Customer
WHERE CreatedOn >= '2016-12-02:00:00:00'

--USING DATE FORMAT
SELECT * FROM Customer
WHERE CreatedOn >= '2016-12-02'

=> OTHER WAYS TO COMPARE

--USING DATE FORMAT
SELECT * FROM Customer
WHERE CreatedOn >= '2016-12-02' 
 AND CreatedOn <= '2015-12-02'

--USE OF BETWEEN OPERATOR.
SELECT * FROM Customer
WHERE CreatedOn BETWEEN '2016-12-02' 
   AND '2015-12-02'

I hope you are enjoying with this post! Please share with you friends!! Thank you!!!