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!!!

SHARES

Share

Pin it

Tweet

Share

Share

Share

Buffer

Print

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link.. My Tech Blog - https://www.code-sample.com/ My Books - Book 1 and Book 2