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!!!
Angular, React, JavaScript, Java, PHP, SQL, C#, Vue, NodeJs, TypeScript and Interview Questions Answers