Skip to Content.
Sympa Menu

freetds - [freetds] php, mssql, datetime problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Agustín Moyano" <moyanoster AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] php, mssql, datetime problem
  • Date: Tue, 30 May 2006 13:15:17 -0300

Hello everyone, I hope someone can help me.

First of all, I'm using php in a Suse 10 with Apache that connects to a
mssql.
The problem I have is that I make a select to get some data from a datetime
field. That data is stored in a variable, and when I try to use that same
data to make an other select to the same database I get the following error:


Error converting data type varchar to datetime (severity 16)

When I do that same select in a query analyzer it works ok.
Does anybody knows what the problem might be?... I'm really lost here.

Agustín.

Ps: The format of the datetime that the database gives from a select is
dd/mm/YYYY, I don't know if that's a problem..




Archive powered by MHonArc 2.6.24.

Top of Page