Heidi dont show miliseconds in timestamp column values in MSSQL

Ken's profile image Ken posted 11 years ago in General Permalink
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's profile image ansgar posted 11 years ago Permalink
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's profile image Ken posted 11 years ago Permalink
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's profile image Ken posted 11 years ago Permalink
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's profile image ansgar posted 11 years ago Permalink
Please watch issue #2513. Yes, I planned to fix that.

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