freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: PHP calling Stored Proc on MS-SQL 7 params bein- g missinterpreted as dates

From: "Bill Thompson" <thompbil AT exchange.uk.ml.com>
To: freetds AT franklin.oit.unc.edu
Subject: Re: PHP calling Stored Proc on MS-SQL 7 params bein- g missinterpreted as dates
Date: Fri, 21 Jun 2002 11:50:43 -0400

have a look at "SET options" in the SQL server online help.
Particularly "set DATEFORMAT", which affects how character strings
representing dates are interpreted.
The default is m/d/y which means your '20/6/02' date would screw up ?

Re: PHP calling Stored Proc on MS-SQL 7 params bein- g missinterpreted as dates, Bill Thompson, 06/21/2002