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?
Heidi dont show miliseconds in timestamp column values in MSSQL
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?
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?
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/
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/
Please watch issue #2513. Yes, I planned to fix that.
Please login to leave a reply, or register at first.