Skip to Content.
Sympa Menu

freetds - datetime format

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bradley Bell <bradleyb AT u.washington.edu>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: datetime format
  • Date: Thu, 13 Dec 2001 18:10:28 -0800


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




Archive powered by MHonArc 2.6.24.

Top of Page