CODEWITHSUNDEEP
sqlsql-serverdatetimeroundingdatetime2
Tyler Antoni
Tyler Antoni

Reputation: 1

Rounding issue from DateTime to DateTime2 SQL v14.0.1000.169

I am attempting to round DateTime to DateTime2, and I was able to round it down to DateTime is rounding to .157, while DateTime2 is rounding to .157000, but DateTime still does not equal DateTme2 when comparing. This is my code:

DECLARE @dt2 datetime2(7),
@dt datetime;
SET @dt2 = '2016-07-11T13:50:11.157';

SET @dt = @dt2;

IF @dt = @dt2
PRINT 'The Same (Implicit);

I have also tried:

declare @dt2 datetime2(7) = '2016-07-11T13:50:11.157'
    declare @dt datetime
    set @dt = @dt2


SELECT
@dt2 AS [Datetime2 value]
, @dt AS [Datetime value]
, CONVERT(DATETIME2,@dt) AS [Datetime converted to Datetime2]
, CONVERT(DATETIME2,@dt2) AS [Datetime2 converted to Datetime2]
, CONVERT(DATETIME,@dt) AS [Datetime converted to Datetime]
, CONVERT(DATETIME,@dt2) AS [Datetime2 converted to Datetime]`

and in the results table it shows:

DateTime2 Value - 2016-07-11 13:50:11.1570000
DateTime value - 2016-07-11 13:50:11.157
Datetime to DateTime2 - 2016-07-11 13:50:11.1566667

Upvotes: 0

Views: 181

Answers (0)

Related Questions