[freetds] SQL Server 2008: Support for TIME(n) data type

Sebastien FLAESCH sf at 4js.com
Fri Jan 30 10:20:16 EST 2009


Sorry my mistake, was compiling my code with wrong ifdefs...

Don't investigate further, I must first double check what I am using to bind TIME(N) columns.

Seb

Sebastien FLAESCH wrote:
> Hi all,
> 
> I was wondering if FreeTDS supports the new TIME(n) type of SQL Server 2008.
> 
> I try to bind an SQL Parameter with  SQL_C_TYPE_TIME / SQL_TYPE_TIME using
> a TIME_STRUCT C structure, but I get following error:
> 
>   |   sqlstate      : 42000
>   |   sqlerrd2      : -402
>   |   sql message   : [FreeTDS][SQL Server]The data types time and datetime are incompatible in the equal to operator.
> 
> Is this type supported and if yes do you have regression tests?
> 
> It is actually a TIME(0) in the SQL Server 2008 database.
> 
> Thanks a lot,
> Seb
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 



More information about the FreeTDS mailing list