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

Sebastien FLAESCH <[email protected]> Fri, 30 Jan 2009 15:57:00 +0100

Newsgroups	gmane.comp.db.tds.freetds
Organization	Four J's Development Tools
Message-ID	<[email protected]>

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