declare @date datetime
set @date = Convert(datetime,'2008-01-01')
while @date <= '2008-01-31'
begin
print convert(nvarchar(10), @date, 120)
set @date=dateadd(day, 1, @date)
end
计算两个时间的时间差
select datediff(n,Convert(datetime,'08:30:00'),Convert(datetime,'08:53:00'))
当前星期几
select datepart(weekday,getDate()) - 1
当前日期
select Convert(nvarchar(10),getdate(),120)
当前时间
select Convert(nvarchar(10),getdate(),108)
set @date = Convert(datetime,'2008-01-01')
while @date <= '2008-01-31'
begin
print convert(nvarchar(10), @date, 120)
set @date=dateadd(day, 1, @date)
end
计算两个时间的时间差
select datediff(n,Convert(datetime,'08:30:00'),Convert(datetime,'08:53:00'))
当前星期几
select datepart(weekday,getDate()) - 1
当前日期
select Convert(nvarchar(10),getdate(),120)
当前时间
select Convert(nvarchar(10),getdate(),108)