Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Burgess, Trevor - HMS" <Trevor.Burgess AT haysdx.co.uk>
  • To: 'TDS Development Group' <freetds AT franklin.oit.unc.edu>
  • Subject: Re: PHP calling Stored Proc on MS-SQL 7 params bein - g missinterpreted as dates
  • Date: Mon, 24 Jun 2002 10:47:47 +0100


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.
**********************************************************************




  • Re: PHP calling Stored Proc on MS-SQL 7 params bein - g missinterpreted as dates, Burgess, Trevor - HMS, 06/24/2002

Archive powered by MHonArc 2.6.24.

Top of Page