In summary:
SELECT
CAST('2003-10-03 15:15:59. 0013621 +00:00' AS time(7)) AS 'time',
CAST('2003-10-03 15:15:59. 0013621 +00:00' AS date) AS 'date',
CAST('2003-10-03 15:15:59.153' AS smalldatetime) AS
'smalldatetime',
CAST('2003-10-03 15:15:59.153' AS datetime) AS 'datetime',
CAST('2003-10-03 15:15:59. 0013621 +00:00' AS datetime2(7)) AS
'datetime2',
CAST('2003-10-03 15:15:59.0013621 +00:00' AS datetimeoffset(7)) AS
'datetimeoffset';
Pick any one, or more, of six suitable.
time date smalldatetime datetime datetime2 datetimeoffset
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
15:15:59.0013621 2003-10-03 2003-10-03 15:16:00 2003-10-03 15:15:59.153 2003-10-03 15:15:59.0013621 2003-10-03 15:15:59.0013621 +00:00