Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Sebastien FLAESCH <sf AT 4js.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SQL Server 2008: Support for TIME(n) data type
  • Date: Fri, 30 Jan 2009 16:41:30 +0100

I believe SQL_C_TYPE_DATE / SQL_TYPE_DATE / DATE_STRUCT is not supported...
right?

I get this error:

SQL State: HY004
Message : [FreeTDS][SQL Server]Invalid data type

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






Archive powered by MHonArc 2.6.24.

Top of Page