FreeTDS Development Group

[Bradley Bell <bradleyb AT u.washington.edu>]

Hi, when selecting a datetime value using freetds, I get values such as:
"Dec 13 2001 05:58PM"
Whereas the same select statement in the MS SQL Query analyzer give:
"2001-12-13 17:58:55.000"

Since I need to be able to convert back and forth between datetime values
and unix timestamps, I need to at least have the number of seconds
(millisecs don't matter).

Is this a problem in FreeTDS, or a limitation of the TDS protocol, or what?
Is it possible to make FreeTDS always return the number of seconds in
datetime fields?

(I don't want to use CONVERT, because the select statements in this
application should remain portable)

thanks,
Brad

-- 
Bradley Bell
Computer Support Analyst
University of Washington
Classroom Support Services