-
changing oracle query statement into ms sql
i am trying to list of dates between two dates.
i had tried everything, but still didn't work out.
examples : start date = 01/12/2006 (in dd/mm/yyyy format)
end date = 06/12/2006
so the output should be
01/12/2006
02/12/2006
03/12/2006
04/12/2006
05/12/2006
06/12/2006
this the query in oracle
select to_date(:start_date,'dd-mon-yyyy') + rownum -1
2 from all_objects
3 where rownum <=
to_date(:end_date,'dd-mon-yyyy')-to_date(:start_date,'dd-mon-yyyy')+1
so,please anybody who knows the statement in ms sql..help me..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|