FreeTDS Development Group

["Curt Hagenlocher" <curt AT hagenlocher.org>]

"Mark Lontsman" <mark.lontsman AT longbow.com> wrote:

> When I call ResultSetMetaData.getColumnType on the datetime
> field, it throws exception saying that it can't determine the
> type.

The following code works for me:

        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("select FOO from bar");
        ResultSetMetaData md = rs.getMetaData();
        System.out.println(md.getColumnType(1));

It returns a value of 93 (sql.Types.TIMESTAMP) for both
datetime and smalldatetime fields in SQL Server 7.0.
                        
Is this on par with what you're trying?


--
Curt Hagenlocher
curt AT hagenlocher.org