FreeTDS Development Group

["Julien de Murcia" <demurcia AT sablet.grenoble.hp.com>]

Hi everybody

I'am new to this list, so I don't know if this problem has already been
submitted. I've been using freetds on ms sql 7.0, and it use to worked
pefectly. Unfortunately, since someone has patched msql server with SP2  the
db returns wrong dates on select statement. I try to read a date/time column
and convert it  with this code

...
ResultSet set = statement.executeQuery("select account_update_time from
account where account_id=" + account_id);
while (set.next()) {
    String uTime = set.getString("account_update_time").trim();
    long  updateTime   = Timestamp.valueOf(uTime).getTime();
}
...

"account_update_time" looks ok with ms query analyser in my db, but  with
freetds some (not all of them) are wrong. I've also tried the same code with
sprinta and it worked Ok.

Thanks,
Julien de Murcia