narasiman rao

narasiman rao

  • NA
  • 519
  • 766k

from using table between two dates get the in between dates

Mar 19 2017 9:44 AM
 
 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
 
 
 

Answers (5)