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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: f dot ledoeuff at hud dot ac dot uk
New email:
PHP Version: OS:

 

 [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 11:01:30 2024 UTC