SQL Server date times explained

2023-01-03 03:57:38
SQL Server hashnode


declare @this_datetime datetime = getutcdate()
declare @this_datetime2 datetime2 = getutcdate()
declare @this_smaldatetime smalldatetime = getutcdate()

select @this_datetime, @this_datetime2, @this_smaldatetime

select datalength(@this_datetime), datalength(@this_datetime2), datalength(@this_smaldatetime)