declare @date_start datetime,@date_stop datetime,@type varchar(50)
set @type='SS_type'
set @date_start='2020-10-1 00:00:000'
while @date_start<='2020-5-6 00:00:000'
begin
insert into Records(EType,date_start,date_stop)
select @type,@date_start,
min(date_start)
from Records
where date_start>@date_start and date_start<DATEADD(MONTH,1,@date_start)
group by CONVERT(varchar(6),[date_start],112)
set @date_start=DATEADD(MONTH,1,@date_start)
end
SQL 插入一条数据,当月1日的零点到表中当月的最小时间
最新推荐文章于 2023-06-05 15:45:32 发布