FreeTDS Development Group

["Mark Lontsman" <mark.lontsman AT longbow.com>]

Curt,

I think I was doing the same thing, but I will test it out further, just to
make sure. Thanks.

Mark

----- Original Message -----
From: "Curt Hagenlocher" <curt AT hagenlocher.org>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Sent: Wednesday, September 26, 2001 4:24 PM
Subject: [freetds] Re: Sql 7 date


> "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
>
> ---
> You are currently subscribed to freetds as: [mark.lontsman AT longbow.com]
> To unsubscribe, forward this message to
$subst('Email.Unsub')