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

go to bug id or search bugs for

Bug #38988 Chaning mssql.datetimeconvert has no effect
Submitted: 2006-09-29 06:47 UTC Modified: 2006-10-01 22:24 UTC
From: wiggum24 at gmail dot com Assigned:
Status: Not a bug Package: MSSQL related
PHP Version: 5.1.6 OS: Redhat Enterprise Linux
Private report: No CVE-ID: None
View Developer Edit
 [2006-09-29 06:47 UTC] wiggum24 at gmail dot com 
Description:
------------
Trying to set mssql.datetimeconvert to Off in php.ini doesn't work. phpinfo() reports it as On, and the behaviour of the recordset reflects the same.

I've confirmed php is picking up the correct php.ini, and my php.ini contains no errors.

Calling ini_set("mssql.datetimeconvert","Off"); before I do the query will set the value and the queries will return correctly.

Reproduce code:
---------------
No errors, the setting just doesn't apply.

Expected result:
----------------
datetimes should appear as:
2006-07-20 16:32:00

Actual result:
--------------
datetimes appear as:
Jul 20 2006 04:32PM

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-09-29 09:09 UTC] tony2001@php.net 
>Trying to set mssql.datetimeconvert to Off in php.ini >doesn't work.
>phpinfo() reports it as On, and the behaviour of the >recordset reflects the same.
Which php.ini is used by PHP according to phpinfo()? Which php.ini did you change? Did you restart the web-server?
 [2006-09-29 15:03 UTC] fmk@php.net 
Works fine here.

Did you remove ; in front of the line?
 [2006-10-01 22:24 UTC] wiggum24 at gmail dot com 
correct php.ini, the ; character was removed. Nothing that silly :)

Found it, I had a php extension that wasn't working properly. No settings were applying after the line that enabled it in php.ini, but php was still working fine and not throwing errors.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Tue Dec 02 19:00:01 2025 UTC