bisonn icon

Dates

bisonn | PRO | 07/15/19 08:06:40 PM UTC | 0 ⭐ | 6388 πŸ‘οΈ | Never ⏰ | []
T-SQL |

190 B

|

None

|

0 πŸ‘

/

0 πŸ‘Ž

declare @d1 datetime = '2000-01-01', @d2 datetime = '3000-01-01'
Β 
;with cte as (
select @d1 as n 
union all
select n + 1
from cte where n < @d2
)
select n from cte option (maxrecursion 0)

Comments

  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    πŸ‘

    /

    πŸ‘Ž

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    πŸ‘

    /

    πŸ‘Ž