By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE @date1 datetime=GETDATE()
DECLARE @date2 DATETIME2(3)=GETDATE()
SELECT CONVERT(VARCHAR,@date1, 114),CONVERT(VARCHAR,@date2,114)
| (No column name) | (No column name) |
|---|---|
| 18:24:45:973 | 18:24:45.973 |