SQL2008R2: DATETIME2 TO DATETIME CAST ISSUE.

Hmm.. same problem.

DECLARE @DATETIME2 DATETIME2

DECLARE @DATETIME2_PLUS DATETIME2(3)

1. 2013-06-27 09:16:50.7803633

2. 2013-06-27 09:16:50.781

3. 2013-06-27 09:16:50.780

3 <> 2

DECLARE @DATETIME2 DATETIME2

DECLARE @DATETIME2_PLUS DATETIME2

1. 2013-06-27 09:17:57.5952807

2. 2013-06-27 09:17:57.5962807

3. 2013-06-27 09:17:57.597

3 <> 2

---

itai