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

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.
ASK Questions
SQL Server NodeJs TypeScript JavaScript Angular SQL Server My Book