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

浙公网安备 33010602011771号