from using table between two dates get the in between dates

narasiman rao

9y946

My table as follows

select * from plandate

fromdate todate

2017-03-02 2017-03-09

from the above table i want the ouput as follows

2017-03-03

2017-03-04

2017-03-05

2017-03-06

2017-03-07

2017-03-08

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.

Manish Kumar9y ago
try this also ....

declare @tbl table (misDate date)

declare @fromdate date,@todate date,@tempdate date

set @fromdate='2017-03-02'
set @todate='2017-03-09'

while (@fromdate<@todate)
begin
insert into @tbl select dateadd(dd,1,@fromdate)
set @fromdate=dateadd(dd,1,@fromdate)
end
select * from @tbl where misdate<>@todate
0
Pravat Kumar9y ago
Hi,
Please Try this

SELECT Convert(VARCHAR(10), DateColumn, 126)
FROM plandate
WHERE Convert(VARCHAR(10), DateColumn, 126) BETWEEN '2017-03-02'
AND '2017-03-09'
ORDER BY Day(createdDate) ASC

0
Midhun Tp9y ago
Hi,

Please try below query -
DECLARE @FromDate DATE = '2017-03-02',
@ToDate DATE = '2017-03-09';
SELECT TOP (DATEDIFF(DAY, @FromDate, @toDate)-1)
Date = DATEADD(DAY, ROW_NUMBER() OVER(ORDER BY a.object_id), @FromDate)
FROM sys.all_objects a
CROSS JOIN sys.all_objects b;
0
Dinesh Santhalingam9y ago
Try like this ,It will Work..I think....
string connectionstring = @"Data Source";
string sql="Select * from table Where (Time > #" + fromdate + "# AND Time < #" + todate + "#")";
using (SqlConnection Connection = new SqlConnection((connectionstring)))
{
using (SqlCommand myCommand = new SqlCommand(sql, Connection))
{
Connection.Open();
using (SqlDataReader myReader = myCommand.ExecuteReader())
{
DataTable dt = new DataTable();
dt.Load(myReader);
Connection.Close();
         }
      }
}
0
Naveen Kumar9y ago
Hi, please find the query below

DECLARE @MinDate DATE = '20140101',
@MaxDate DATE = '20140106';
SELECT TOP (DATEDIFF(DAY, @MinDate, @MaxDate) + 1)
Date = DATEADD(DAY, ROW_NUMBER() OVER(ORDER BY a.object_id) - 1, @MinDate)
FROM sys.all_objects a
CROSS JOIN sys.all_objects b;

0