How to Write Query for From To To date

dhoni kholi

6y1.2k.NET

This is My table value

My Query

This is my output

But I Want '2020-01-25' date Record also

How to write query For get Todate also

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta6y ago
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
+1
dhoni kholi6y ago
Hi,
Amit Gupta sir

It was DateTime Data type
0
dhoni kholi6y ago
Hi
Malvik Bhavsar Sir

I was use Group By ; Some records not retriew
0
Harsh Shah6y ago
You must try this query.

select * from Exam where ExamDate >= '2020-01-22' and ExamDate <= '2020-01-25'
0
Vrushali Ghodke6y ago
hi, dhoni try out this quey SELECT * FROM Bill WHERE Date >= '2020-01-22' and Date <= '2020-01-25'
0
Laxmidhar Sahoo6y ago
1. SELECT * FROM Bill WHERE Date
2. gt;= CAST('2020-01-22T00:00:00.000' AS datetime) and <= CAST('2020-01-25T24:59:38.544' AS datetime)
+3

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

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'

Is the datatype of date column is date?