how to get the between date using from date and to date

Question

i have from date as 01/06/2017

To date as 08/06/2017

i want to display in between those date from date and to date.

for that how to write the sql server query.

i want the output as

02/06/2017
03/06/2017
04/06/2017
05/06/2017
06/06/2017
07/06/2017

for that how to write the query in sql server

Rafnas T P · Answer

you can give in where condition like below select * from Tablename where dateofpurchase between fromdate and todate or select * from Tablename where dateofpurchase between '01/06/2017' and '08/06/2017'

Nitin Sontakke · Answer

Something like this will be quite useful: https://www.mssqltips.com/sqlservertip/2800/sql-server-function-to-return-a-range-of-dates/ Especially because it is TVF and can be used in join s.

Ahmed JS · Answer

Hi friends select * from tablename where convert(varchar(12)RequiredDate103) between ' 02/06/2017 ' and ' 07/06/2017 ' www.sqlneed.blogspot.com https://youtu.be/mof97thsmzs

Manish Kumar · Answer

HI Rao Check this..... declare @tbl table (alldate datetime) declare @fromdate datetime@todate datetime@initial datetime set @fromdate='01/06/2017' set @todate='08/06/2017' set @initial=@fromdate --select convert(varchar(10)@fromdate126) while (@initial begin insert into @tbl select @initial set @initial=DATEADD(dd1@initial) end select * from @tbl where alldate @fromdate

Ramesh Palanivel · Answer

Hi Narasiman Do you want to fetch this record from table or do you want to write dynamic logic?