Date Query for a single Date Range

Question

Hi,
The Date field in the Table is actually a DateTime field. I need to be able to do either of the following Queries:

SELECT Date FROM tblHistory
WHERE Date BETWEEN '2021-02-22' AND '2021-02-22'

or

SELECT Date FROM tblHistory
WHERE Date LIKE '2021-02-22%'

Neither option returns any rows for a single date

Answer 1

Hi @Alvord, Timothy ,

Please try the following:

SELECT Date FROM tblHistory   
WHERE FORMAT(Date, 'yyyy-MM-dd') = '2021-02-22'  

or, if you want to use between, then

SELECT Date FROM tblHistory   
WHERE FORMAT(Date, 'yyyy-MM-dd') BETWEEN '2021-02-22' AND '2021-02-23'  

----------

If the above response is helpful, please accept as answer and up-vote it. Thanks!

Answer 2

WHERE Date >= '2021-02-22' AND Date < '2021-02-23'

Tom

Answer 3

SELECT Date FROM tblHistory
WHERE Date BETWEEN '20210222' AND '20210223'