"DATE" data type is deployed as "SMALLDATETIME" in SQL 2008

Description

I have a changeset below to create a table called "BATCH" with 2 columns below :

<changeSet author="NK" id="1">
<createTable schemaName="dbo" tableName="BATCH">
<column autoIncrement="true" name="sid" type="BIGINT">
<constraints nullable="false" primaryKey="true" primaryKeyName="PK_Batch"/>
</column>
<column name="default_date" type="DATE"/>
</createTable>
</changeSet>

When deployed against SQL Server 2008, the DEFAULT_DATE column is created as "SMALLDATETIME" where
what we really want is "DATE" data type.

Environment

Windows SQL Server 2008 R2

Activity

Show:
Nathan Voxland
September 24, 2013, 1:16 PM

Fixed issue so that both sqlserver and sybase return "date" for date datatypes.

If you are wanting to use datetime2 use a extension as described or a changelog parameter or modifysql if you cannot just define the type as "datetime2" in your changelog.

Fixed
Your pinned fields
Click on the next to a field label to start pinning.

Reporter

Nick Kladwang