#24966 [NEW]: Date format problem

From: f dot ledoeuff at hud dot ac dot uk Operating system: win nt4 PHP version: 4.3.1 PHP Bug Type: MSSQL related Bug description: Date format problem Description: ------------ Hi all, I am having troubles to save dates in my mssql database using PHP My query is perfectly fine: insert into tblactivity_dts (actid, start_date, end_date) values ('885347739','10/12/2003','10/01/2004') but the dates saved in my DB are 12/10/2003 and 01/10/2004 However if I run the query in sql server enterprise manager, the dates are stored properly. I have set the server configuration to british and set mssql.datetimeconvert to 0 .... fred -- Edit bug report at http://bugs.php.net/?id=24966&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=24966&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=24966&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=24966&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=24966&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=24966&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=24966&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=24966&r=support Expected behavior: http://bugs.php.net/fix.php?id=24966&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=24966&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=24966&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=24966&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=24966&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=24966&r=dst IIS Stability: http://bugs.php.net/fix.php?id=24966&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=24966&r=gnused