freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: FreeBSD / MSSQL / FreeTDS / PHP - data type problem
- 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.
-
FreeBSD / MSSQL / FreeTDS / PHP - data type problem,
Wes, 03/13/2002
- <Possible follow-up(s)>
- Re: FreeBSD / MSSQL / FreeTDS / PHP - data type problem, Kaeptn Weltall, 03/13/2002
Archive powered by MHonArc 2.6.24.