[dba-SQLServer] Date format

Thanks Stuart!

John W. Colby
www.ColbyConsulting.com

On 6/18/2011 10:37 PM, Stuart McLachlan wrote:
> Found it:
> http://msdn.microsoft.com/en-us/library/ms180878.aspx#ODBCDatetimeFormat
>
> <quote>
> Backward Compatibility for Down-level Clients
>
> Some down-level clients do not support the time, date, datetime2 and datetimeoffset data
> types added in SQL Server 2008. The following table shows the type mapping between an
> up-level instance of SQL Server 2008 and down-level clients.
> </quote>
>
> Looks like you are using one of SQL Server 2008's new date/time data types for that field and
> accessing it via ODBC.   MS in their wisdom have decided to convert it and return a
> YY-MM-DD string instead of a numeric value of some type.
>
> Best bet is to change the field type in SQL Server to one of the older datetime or
> smalldatetime types.
>