select date with ms sql 7.0 SP2
Julien de Murcia
demurcia at sablet.grenoble.hp.com
Thu Aug 10 03:35:13 EDT 2000
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
More information about the FreeTDS
mailing list