Heidi dont show miliseconds in timestamp column values in MSSQL

Ken posted 4 years ago in General
I have important timestamp columns (datatime column type).
Values in that columns have miliseconds.

Heidi shows this values only in seconds precsion.
MSSQL: "2013-08-01 00:00:00.987"
Heidi shows: "2013-08-01 00:00:01"

Is it possilbe to view miliseconds from MSSQL datateime columns?
ansgar posted 4 years ago
Well, you are the first one reporting that DATETIME types in MSSQL support microseconds - so far the reason for why HeidiSQL does not show that :)

As newer MySQL and MariaDB releases also support microseconds, and HeidiSQL also supports that as reported, it should not be too hard to extend that to relevant MSSQL versions. Since which MSSQL release are microseconds supported?
Ken posted 4 years ago
I need miliseconds, not microseconds.
MSSQL 2000 and 2005 supported datetime with accuracy of one three-hundredth of a second (equivalent to 3.33 milliseconds or 0.00333 seconds). Values are rounded to increments of .000, .003, or .007 seconds
MSSQL 2008 have new data types including DATETIME2 (YYYY-MM-DD hh:mm:ss:nnnnnnnm - is accurate to 100 nanoseconds

Look for more info at:http://www.connectionstrings.com/sql-server-data-types-reference/
Ken posted 4 years ago
I need solution for this problem or will have to use another SQL tool.
Does anyone plan to fix it in the near future?
ansgar posted 4 years ago
Please watch issue #2513. Yes, I planned to fix that.

Please login to leave a reply, or register at first.