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

Heidi dont show miliseconds in timestamp column values in MSSQL

User, date Message
Written by Ken
1 year ago
Category: General
3 posts since Thu, 01 Aug 13
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?
Written by ansgar
1 year ago
4960 posts since Fri, 07 Apr 06
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?
Written by Ken
1 year ago
3 posts since Thu, 01 Aug 13
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/
Written by Ken
1 year ago
3 posts since Thu, 01 Aug 13
I need solution for this problem or will have to use another SQL tool.
Does anyone plan to fix it in the near future?
Written by ansgar
1 year ago
4960 posts since Fri, 07 Apr 06
Please watch issue #2513. Yes, I planned to fix that.
 

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