php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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 Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
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

Add a Patch

Pull Requests

Add a Pull Request

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: Thu Mar 28 12:01:27 2024 UTC