#24966 [Opn->Bgs]: Date format problem

ID: 24966 Updated by: sniper@php.net Reported By: f dot ledoeuff at hud dot ac dot uk -Status: Open +Status: Bogus Bug Type: MSSQL related Operating System: win nt4 PHP Version: 4.3.1 New Comment: Too old version (4.3.2 is out and also 4.3.3RC2 is out) plus I think this was dealt with in some other bug report, try search the old reports for this. Previous Comments: ------------------------------------------------------------------------ [2003-08-06 09:46:00] f dot ledoeuff at hud dot ac dot uk 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 this bug report at http://bugs.php.net/?id=24966&edit=1