[DDLUTILS-17] MS SQL Server DATETIME column

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Cannot Reproduce
• Component/s: Core - SqlServer
• Environment: MS SQL Server 2000
• Assignee: Thomas Dudziak
• Reporter: dan meany
• Created: 16/Sep/05 00:47
• Updated: 13/Jul/06 14:52
• Resolved: 13/Jul/06 13:51

Description

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