from using table between two dates get the in between dates

Question

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

Manish Kumar · Answer

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 begin insert into @tbl select dateadd(dd1@fromdate) set @fromdate=dateadd(dd1@fromdate) end select * from @tbl where misdate @todate

Pravat Kumar · Answer

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

Midhun T P · Answer

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;

Dinesh Santhalingam · Answer

Try like this It will Work..I think.... string connectionstring = @Data Source; string sql =  Select * from table Where (Time > # + fromdate + # AND Time ; 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(); } } }

Naveen Kumar · Answer

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;