SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table test (
  col_smalldatetime smalldatetime,
  col_datetime datetime,
  col_datetime2 datetime2
);
insert into test values ('2022-01-02 03:04:05', '2022-01-02 03:04:05', '2022-01-02 03:04:05');
1 rows affected

select * from test;


col_smalldatetime
col_datetime
col_datetime2


2022-01-02 03:04
2022-01-02 03:04:05.000
2022-01-02 03:04:05.0000000