hi, days ago i read this microsoft note:
http://msdn.microsoft.com/en-us/library/ms182418.aspx

Use the time, date, datetime2 and datetimeoffset data types for new work. These types align with the SQL Standard. They are more portable. time, datetime2 and datetimeoffset provide more seconds precision. datetimeoffset provides time zone support for globally deployed applications.

....

smalldatetime is not ANSI or ISO 8601 compliant.

by these, I think you should change in function date_field_schema of date.install line 22

    'sqlite_type' => 'VARCHAR', 
   - 'sqlsrv_type' => 'smalldatetime',
   + 'sqlsrv_type' => 'datetime2(0)',

best regads
rafa

Comments

KarenS’s picture

KarenS CreditAttribution: KarenS commented
Component: Code » Non-MYSQL Databases
Priority: Minor » Normal

Flagging non-MYSQL issues. I'm not opposed to this change, but someone else using this database needs to confirm if it makes sense and that it works with the rest of the code.