"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

Reporter

Nick Kladwang

Fix versions

Affects versions

Priority

Trivial
Configure