Skip to Content.
Sympa Menu

freetds - Re: FreeBSD / MSSQL / FreeTDS / PHP - data type problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Kaeptn Weltall" <rl AT w4u.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: FreeBSD / MSSQL / FreeTDS / PHP - data type problem
  • Date: Wed, 13 Mar 2002 09:35:51 -0500


i just can offer you a workaround, while the people
with there head stuck deeper in the freetds-code than
mine may try to solve the problem at the root.

You could convert datetime on the serverside to varchar
like:

select convert(char(24),getdate(), 113)

getdate() returns the current date and time in the format
"datetime". the server function "convert" converts this to
a char using mode 113(european default + milliseconds).
as mode 113 allways consumes 24 chars you can set this
length appropriately. the tds from dbserver to freetds-
client will only see the char format, that hopefully
causes no problems.




Archive powered by MHonArc 2.6.24.

Top of Page