drop table if exists in SQL Server

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

ANIL SINGH

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 Blogs - https://code-sample.com and https://code-sample.xyz
My Book1 - BEST SELLING ANGULAR BOOK (INCLUDING ALL VERSIONS 2, 4, 5, 6, 7)
My Book2 - ANGULAR 2 INTERVIEW QUESTIONS BOOK - Both Books are Available on WorldWide.

www.code-sample.com/. Powered by Blogger.