FreeTDS Development Group

["SCHAEFER,OLIVER (HP-Germany,ex1)" <oliver_schaefer AT hp.com>]

Hello once again,

I've created a table with 4 columns on a MSSQL 7.0
server with following datatypes:

- char(10)
- timestamp
- datetime
- smalldatetime

There is one row containing the values ("test", NULL, "03.03.2000",
"03.03.2000").
Now I fetch the data within a perl script using DBD::Sybase and freetds
0.51.
TDSVER is set to 4.2 ...

This is the OUTPUT:
--BEGIN
test 
0x0000000000014e71 
Feb 07 2036 06:30A 
Mar 03 2036 04:14P
--END

Any Ideas why this happens?

Regards Oliver

-----Original Message-----
From: SCHAEFER,OLIVER (HP-Germany,ex1) [mailto:oliver_schaefer AT hp.com]
Sent: Tuesday, March 06, 2001 3:04 PM
To: TDS Development Group
Subject: [freetds] Re: Timestamp on a BIGENDIAN


Hello,

those are datetime columns with size 8.
 
SQL Server Version is 7.00.623, as far as I
know, no Service Pack installed.

Oliver

-----Original Message-----
From: Brian Bruns [mailto:camber AT ais.org]
Sent: Tuesday, March 06, 2001 3:30 PM
To: TDS Development Group
Subject: [freetds] Re: Timestamp on a BIGENDIAN



Are these actual 'timestamp' columns or are they datatime columns?

If they are datetime columns which service pack are you using?

Brian

On Tue, 6 Mar 2001, Oliver Schäfer wrote:

> hello 2 all,
> 
> is there yet any solution available for the
> problem described in the subject of this message?
> 
> I've tried all the things described in this mailinglist,
> but continue receiving "funny dates".
> 
> I've compiled freetds-0.5.1 on a PA-RISC 1.1 with HP-UX
> and I'm accessing a MSSQL7.0 on a win2k box.
> 
> In addition I use DBD::Sybase-0.91 .
> 
> Any comments?
> 
> Thanx in advance,
> Oliver Schäfer
> 


---
You are currently subscribed to freetds as: [oliver_schaefer AT hp.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')

---
You are currently subscribed to freetds as: [oliver_schaefer AT hp.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')