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
SQL Server date datetime datetime2 smalldatetime
最新推荐文章于 2024-01-18 21:52:05 发布