php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #24966 Date format problem
Submitted: 2003-08-06 09:46 UTC Modified: 2003-08-06 09:55 UTC
From: f dot ledoeuff at hud dot ac dot uk Assigned:
Status: Not a bug Package: MSSQL related
PHP Version: 4.3.1 OS: win nt4
Private report: No CVE-ID: None
View Developer Edit
 [2003-08-06 09:46 UTC] 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-08-06 09:55 UTC] sniper@php.net 
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.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sun Dec 22 06:01:30 2024 UTC