Re: SQL Server 2008: Support for TIME(n) data type
Sebastien FLAESCH <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Organization | Four J's Development Tools |
| Message-ID | <[email protected]> |
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 > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds >