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


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 name="default_date" type="DATE"/>

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


Windows SQL Server 2008 R2


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.

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


Nick Kladwang