SQL Server 2022

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

CREATE TABLE dbo.MyTable 
  (
  ID int IDENTITY (1,1),
  CreateDate DATETIME2(0)  DEFAULT GETUTCDATE() NOT NULL,
  CreateDateSYS DATETIME2(0) DEFAULT SYSUTCDATETIME() NOT NULL
  );
INSERT INTO MyTable (CreateDate, CreateDateSYS) 
VALUES 
  (GETUTCDATE(),GETUTCDATE()),
  (SYSUTCDATETIME(), SYSUTCDATETIME()),
  ('2023-03-30 07:16:45.1','2023-03-30 07:16:45.1'),
  ('2023-03-30 07:16:45.12','2023-03-30 07:16:45.12'),
  ('2023-03-30 07:16:45.123','2023-03-30 07:16:45.123'),
  ('2023-03-30 07:16:45.1234','2023-03-30 07:16:45.1234'),
  ('2023-03-30 07:16:45.12345','2023-03-30 07:16:45.12345')
  ;
7 rows affected

SELECT * FROM MyTable;


ID
CreateDate
CreateDateSYS


1
2023-03-30 07:56:20
2023-03-30 07:56:20

2
2023-03-30 07:56:20
2023-03-30 07:56:20

3
2023-03-30 07:16:45
2023-03-30 07:16:45

4
2023-03-30 07:16:45
2023-03-30 07:16:45

5
2023-03-30 07:16:45
2023-03-30 07:16:45

6
2023-03-30 07:16:45
2023-03-30 07:16:45

7
2023-03-30 07:16:45
2023-03-30 07:16:45


SELECT GETUTCDATE();


(No column name)


2023-03-30 07:56:20.487


CREATE TABLE dbo.MyTableFixed 
  (
  ID int IDENTITY (1,1),
  CreateDate DATETIME2(7) NOT NULL DEFAULT GETUTCDATE(),
  CreateDateSYS DATETIME2(7) NOT NULL DEFAULT SYSUTCDATETIME()
  );
INSERT INTO MyTableFixed (CreateDate, CreateDateSYS) 
VALUES 
  (GETUTCDATE(),GETUTCDATE()),
  (SYSUTCDATETIME(), SYSUTCDATETIME()),
  ('2023-03-30 07:16:45.1','2023-03-30 07:16:45.1'),
  ('2023-03-30 07:16:45.12','2023-03-30 07:16:45.12'),
  ('2023-03-30 07:16:45.123','2023-03-30 07:16:45.123'),
  ('2023-03-30 07:16:45.1234','2023-03-30 07:16:45.1234'),
  ('2023-03-30 07:16:45.12345','2023-03-30 07:16:45.12345')
  ;
7 rows affected

SELECT * FROM MyTableFixed;


ID
CreateDate
CreateDateSYS


1
2023-03-30 07:56:20.5033333
2023-03-30 07:56:20.5033333

2
2023-03-30 07:56:20.5043755
2023-03-30 07:56:20.5043755

3
2023-03-30 07:16:45.1000000
2023-03-30 07:16:45.1000000

4
2023-03-30 07:16:45.1200000
2023-03-30 07:16:45.1200000

5
2023-03-30 07:16:45.1230000
2023-03-30 07:16:45.1230000

6
2023-03-30 07:16:45.1234000
2023-03-30 07:16:45.1234000

7
2023-03-30 07:16:45.1234500
2023-03-30 07:16:45.1234500

ID	CreateDate	CreateDateSYS
1	2023-03-30 07:56:20	2023-03-30 07:56:20
2	2023-03-30 07:56:20	2023-03-30 07:56:20
3	2023-03-30 07:16:45	2023-03-30 07:16:45
4	2023-03-30 07:16:45	2023-03-30 07:16:45
5	2023-03-30 07:16:45	2023-03-30 07:16:45
6	2023-03-30 07:16:45	2023-03-30 07:16:45
7	2023-03-30 07:16:45	2023-03-30 07:16:45

ID	CreateDate	CreateDateSYS
1	2023-03-30 07:56:20.5033333	2023-03-30 07:56:20.5033333
2	2023-03-30 07:56:20.5043755	2023-03-30 07:56:20.5043755
3	2023-03-30 07:16:45.1000000	2023-03-30 07:16:45.1000000
4	2023-03-30 07:16:45.1200000	2023-03-30 07:16:45.1200000
5	2023-03-30 07:16:45.1230000	2023-03-30 07:16:45.1230000
6	2023-03-30 07:16:45.1234000	2023-03-30 07:16:45.1234000
7	2023-03-30 07:16:45.1234500	2023-03-30 07:16:45.1234500