select date with ms sql 7.0 SP2
Julien de Murcia
demurcia at sablet.grenoble.hp.com
Thu Aug 10 06:38:35 EDT 2000
On Thu, 10 Aug 2000, Julien de Murcia wrote:
> > 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
> Try this with the latest snapshot and tell us whether you still have
> the problem.
>  ftp://freetds.internetcds.com/pub/freetds_jdbc/
> Bob Kline
> mailto:bkline at rksystems.com
Same thing, it's not working with the snapshot. My sql server version is
7.00.839. Do I have to specify the version in the connect string of freetds
(I'm currently using "jdbc:freetds:sqlserver//host/db") ?
Julien de Murcia.
More information about the FreeTDS