SQLserver 查询:
select dateadd(dd,num,@begintime) FROM (
SELECT ROW_NUMBER() OVER (ORDER BY ID)-1 AS num FROM sysobjects
) KK where dateadd(dd,num,@begintime) <=@endtime
EF 获取两个时间段的日期:
SQLserver 查询:
select dateadd(dd,num,@begintime) FROM (
SELECT ROW_NUMBER() OVER (ORDER BY ID)-1 AS num FROM sysobjects
) KK where dateadd(dd,num,@begintime) <=@endtime
EF 获取两个时间段的日期: