dhoni kholi

dhoni kholi

  • 1.7k
  • 169
  • 3.3k

How to Write Query for From To To date

Jan 26 2020 9:06 AM
This is My table value
 
 NameDate Amount Tax 
 Rajesh22-01-2020 11000 18  
 Karthi22-01-20208500 18 
 Surya24-01-2020 10000 18 
 Saravana25-01-2020 10000 18 
 
My Query
  1. SELECT * FROM Bill WHERE Date BETWEEN '2020-01-22' and '2020-01-25'  
This is my output 
 
NameDate Amount Tax
Rajesh22-01-2020 11000 18
Karthi22-01-20208500 18
Surya24-01-2020 10000 18
 
But I Want '2020-01-25' date Record also 
 
How to write query For  get Todate also 

Answers (9)