This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
Some background info: Product Version: NetBeans IDE Dev (Build 2013-01-24_09-04-16 ) Java: 1.7.0_11; Java HotSpot(TM) 64-Bit Server VM 23.6-b04 Runtime: Java(TM) SE Runtime Environment 1.7.0_11-b21 System: Windows 7 version 6.1 running on amd64; Cp1252; en_US (nb) Using jTDS 1.3.0 JDBC driver to connect to a MS SQL Server. Any column that is of the datatype of datetime is interpreted as a timestamp datatype inside of Netbeans. How to replicate: 1) Create a table on a mssql server that has a column of type datetime. You can use Netbeans or any tool, it doesn't matter. 2) Verify that the column really is of type datetime by using SQL Server Management Studio, or a SQL Client written in Java like Aqua Data Studio. 3) Go to Netbeans database browser and right-click on the datetime column and select the "Properties" context menu item. 4) See what it says for "Data type" Actual Results: TIMESTAMP Expected Results: DATETIME
This is caused by JDBC driver for MS SQL Server. (DATETIME is not a JDBC data type.) See http://msdn.microsoft.com/en-us/library/ms378715.aspx, section Datetime Types, This cannot be fixed in NetBeans, because it uses JDBC to accesses the database.