Getting Accurate Records between two dates from the Table of MS SQL SERVER

Raju Katare
12y
4.4k
0
0

Blog

By using following query we will get desired results

SELECT * FROM myTable WHERE convert(nvarchar,dateColumn,112)>=convert(nvarchar,fromDate,112)
AND
convert(nvarchar,dateColumn,112)<=convert(nvarchar,toDate,112)

To Get Accurate Records

Up Next

Get number of days between two dates in sql

Ebook Download

View all

Basic SQL Queries

Read by 19.4k people

Download Now!

Learn

View all