一条语句实现insert newuser select username from user where regtime>=convert(char(10),getdate,120) and regtime<dateadd(day,1,convert(char(10),getdate,120))
insert [newuser] select [username] from [user] where regtime=getdate()
--如果楼主说的getdate()是指今天,那就还要处理时间问题,改用:insert [newuser] select [username] from [user] where regtime>=convert(char(10),getdate(),120) and regtime<dateadd(day,1,convert(char(10),getdate(),120))
select username
from user
where regtime>=convert(char(10),getdate,120)
and regtime<dateadd(day,1,convert(char(10),getdate,120))
select [username] from [user]
where regtime>=convert(char(10),getdate(),120)
and regtime<dateadd(day,1,convert(char(10),getdate(),120))