FreeTDS Development Group

[Sebastien FLAESCH <sf AT 4js.com>]

Hi all,

FYI I have just installed SQL Server 2008 "Katmai" and do some tests.

This 2008 version supports new datatypes:

  DATE
  TIME(n)
  DATETIME2(n)
  DATETIMEOFFSET(n)

I found this in sqlncli.h:

// Driver specific SQL data type defines.
// Microsoft has -150 thru -199 reserved for Microsoft SQL Server Native 
Client driver usage.
#define SQL_SS_VARIANT                      (-150)
#define SQL_SS_UDT                          (-151)
#define SQL_SS_XML                          (-152)
#define SQL_SS_TABLE                        (-153)
#define SQL_SS_TIME2                        (-154)
#define (-155)


// New Date Time Structures
// New Structure for TIME2
typedef struct tagSS_TIME2_STRUCT
    {
    SQLUSMALLINT hour;
    SQLUSMALLINT minute;
    SQLUSMALLINT second;
    SQLUINTEGER fraction;
    }   SQL_SS_TIME2_STRUCT;

// New Structure for TIMESTAMPOFFSET
typedef struct tagSS_TIMESTAMPOFFSET_STRUCT
    {
    SQLSMALLINT year;
    SQLUSMALLINT month;
    SQLUSMALLINT day;
    SQLUSMALLINT hour;
    SQLUSMALLINT minute;
    SQLUSMALLINT second;
    SQLUINTEGER fraction;
    SQLSMALLINT timezone_hour;
    SQLSMALLINT timezone_minute;
    }   SQL_SS_TIMESTAMPOFFSET_STRUCT;


Sooner or later this should be supported.

Cheers
Seb