the datetime2 datatype goes to 7 decimal places;
can you show what it is you are trying to do?
With MyCTE (TheTime)
AS
(
SELECT convert(datetime2,'1900-01-01 0:12:14.1241234') UNION ALL
SELECT '1900-01-01 0:08:16.361' UNION ALL
SELECT '1900-01-01 0:08:57.705'
)
SELECT *
From myCTE
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!