FreeTDS Development Group

["Burgess, Trevor - HMS" <Trevor.Burgess AT haysdx.co.uk>]

Thanks Bill that works perfectly

I simply added:
mssql_query("SET DATEFORMAT dmy");
before my proper query and the problem is fixed.

Thanks to everyone for your help

Trevor

-----Original Message-----
From: Bill Thompson [mailto:thompbil AT exchange.uk.ml.com]
Sent: 21 June 2002 16:51
To: TDS Development Group
Subject: [freetds] Re: PHP calling Stored Proc on MS-SQL 7 params bein-
g missinterpreted as dates


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 ?

---
You are currently subscribed to freetds as: [trevor.burgess AT haysdx.co.uk]
To unsubscribe, forward this message to
$subst('Email.Unsub')


**********************************************************************
This message (including any attachments) is confidential and may be 
legally privileged.  If you are not the intended recipient, you should 
not disclose, copy or use any part of it - please delete all copies 
immediately and notify the Hays Group Email Helpdesk at
email.helpdesk AT hays.plc.uk
Any information, statements or opinions contained in this message
(including any attachments) are given by the author.  They are not 
given on behalf of Hays unless subsequently confirmed by an individual
other than the author who is duly authorised to represent Hays.
 
A member of the Hays plc group of companies.
Hays plc is registered in England and Wales number 2150950.
Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
**********************************************************************