How to Write Query for From To To date

Question

This is My table value Name Date Amount Tax Rajesh 22-01-2020 11000 18 Karthi 22-01-2020 8500 18 Surya 24-01-2020 10000 18 Saravana 25-01-2020 10000 18 My Query SELECT * FROM Bill WHERE Date BETWEEN '2020-01-22' and '2020-01-25' This is my output Name Date Amount Tax Rajesh 22-01-2020 11000 18 Karthi 22-01-2020 8500 18 Surya 24-01-2020 10000 18 But I Want '2020-01-25' date Record also How to write query For get Todate also

Laxmidhar Sahoo · Answer

SELECT * FROM Bill WHERE Date gt;= CAST ( '2020-01-22T00:00:00.000' AS datetime) and CAST ( '2020-01-25T24:59:38.544' AS datetime)

Amit Gupta · Answer

There are two option that you can use 1. If column is of datetime SELECT * FROM Bill WHERE Date >= CAST ( '2018-01-22 00:00:00.000' AS datetime) and date CAST ( '2020-01-25 23:59:59.999' AS datetime) 2. Converting the datetime value to date and execute the query

Malvik Bhavsar · Answer

Dear Dhoni, This is because of your date column have DateTime datatype. so you need to convert date into in your where condition. Please check the following example for more clarification. DECLARE @Bill TABLE ( BillDate date ) INSERT INTO @Bill (BillDate) VALUES ( '2020-01-22' ), ( '2020-01-23' ), ( '2020-01-24' ), ( '2020-01-25' ) SELECT * FROM @Bill WHERE BillDate BETWEEN '2020-01-22' and '2020-01-25' go ----------- DECLARE @Bill TABLE ( BillDate datetime ) INSERT INTO @Bill (BillDate) VALUES ( '2020-01-22 00:00:00.000' ), ( '2020-01-23 00:00:00.000' ), ( '2020-01-24 00:00:00.000' ), ( '2020-01-25 15:00:00.000' ) SELECT * FROM @Bill WHERE convert(date, BillDate) BETWEEN '2020-01-22' and '2020-01-25'

Amit Gupta · Answer

Is the datatype of date column is date?

dhoni kholi · Answer

Hi, Amit Gupta sir It was DateTime Data type

dhoni kholi · Answer

Hi Malvik Bhavsar Sir I was use Group By ; Some records not retriew

Harsh Shah · Answer

You must try this query. select * from Exam where ExamDate >= '2020-01-22' and ExamDate

Vrushali Ghodke · Answer

hi, dhoni try out this quey SELECT * FROM Bill WHERE Date >= '2020-01-22' and Date <= '2020-01-25'

Jignesh Kumar · Answer

Hey, Please use this link, https://stackoverflow.com/questions/24192166/sql-server-how-to-select-records-with-specific-date-from-datetime-column

Name	Date	Amount	Tax
Rajesh	22-01-2020	11000	18
Karthi	22-01-2020	8500	18
Surya	24-01-2020	10000	18
Saravana	25-01-2020	10000	18

How to Write Query for From To To date

Answers (9)