SQL Pro not displaying milliseconds correctly.

The following dates have 702 milliseconds difference but are displayed as if the milliseconds are zero.  Also if I do an edit row, the ms is completely missing.  The fields are datetime2(8).   If I do a convert(varchar, date, 121) and convert the date to a string, you can see the ms value is displayed.

 

+-------------------------+-------------------------+
| ingestStartDate         | ingestCompletionDate    |
+-------------------------+-------------------------+
| 2018-10-19 16:48:46.000 | 2018-10-19 16:48:46.000 |
+-------------------------+-------------------------+

 

2018-10-19 16:48:46.2890000       2018-10-19 16:48:46.9910000

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 4 mths agoLast active
  • 1Replies
  • 48Views
  • 2 Following