当你的才华不能撑起你的野心时,就是你该选择学习的时候了!

SQL Server date datetime datetime2 smalldatetime

declare @tbl table(ReportDate date primary key,ReportDate1 datetime,ReportDate2 datetime2,ReportDate3 smalldatetime,AvaliableFlag bit default(0))
insert into @tbl select getdate(),getdate(),getdate(),getdate(),1

select * from @tbl
--2022-10-20    2022-10-20 11:01:54.353    2022-10-20 11:01:54.3533333    2022-10-20 11:02:00    1

select sysdatetime(),getdate(),getutcdate()
--2022-10-20 11:01:54.3568276    2022-10-20 11:01:54.353    2022-10-20 03:01:54.353

 

posted @ 2022-10-20 11:09  hofmann  阅读(42)  评论(0)    收藏  举报