[ http://issues.apache.org/jira/browse/DDLUTILS-17?page=comments#action_12329434 ]
Christoffer Hammarström commented on DDLUTILS-17: ------------------------------------------------- I get DATETIME columns by specifying TIMESTAMP. This is correct, since http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ta-tz_6fn4.asp says "The Transact-SQL timestamp data type is not the same as the timestamp data type defined in the SQL-92 standard. The SQL-92 timestamp data type is equivalent to the Transact-SQL datetime data type." > MS SQL Server DATETIME column > ----------------------------- > > Key: DDLUTILS-17 > URL: http://issues.apache.org/jira/browse/DDLUTILS-17 > Project: DdlUtils > Type: Bug > Environment: MS SQL Server 2000 > Reporter: dan meany > Assignee: Thomas Dudziak > Priority: Minor > > I had trouble creating a MS SQL Server DATETIME column with DdlUtils > (TypeMap.java does not have a DATETIME?). MS SQL Server 2000 does not have a > DATE or TIME column type. They have a DATETIME and a TIMESTAMP. There can > only be one TIMESTAMP column per table, but multiple DATETIMES are ok. > For reference the MS SQL types I have are: > bigint > binary > bit > char > datetime > decimal > float > image > int > money > nchar > ntext > numeric > nvarchar > real > smalldatetime > smallint > smallmoney > sql_variant > text > timestamp > tinyint > uniqueidentifier > varbinary > varchar -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
