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

narasiman rao

9y913

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

5 Replies

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

Nitin Sontakke9y ago
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 joins.
0
Ahmed JS9y ago
Hi friends

select * from tablename where convert(varchar(12),RequiredDate,103) between '02/06/2017' and '07/06/2017'

www.sqlneed.blogspot.com
https://youtu.be/mof97thsmzs
0
Manish Kumar9y ago
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),@fromdate,126)
while (@initial<@todate)
begin
insert into @tbl select @initial
set @initial=DATEADD(dd,1,@initial)

end
select * from @tbl where alldate<>@fromdate
0
Ramesh Palanivel9y ago
Hi Narasiman,

Do you want to fetch this record from table or do you want to write dynamic logic?
0
Rafnas T P9y ago
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'
+1