distal-attribute
distal-attribute
distal-attribute
distal-attribute

Heidi dont show miliseconds in timestamp column values in MSSQL

Ken posted 1 year 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 1 year 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 1 year ago
I need miliseconds, not microseconds.
Anyway....
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 1 year 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 1 year ago
Please watch issue #2513. Yes, I planned to fix that.

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