PHP and SQL Server DateTime Issues
Beware this content is over 3 years old and considered stale. It may no longer be accurate and/or reflect the understanding of the author but remains here for reference only. Please keep this in mind as you use this content.
I’ve been bitten by this apparently little known quirk in PHP5 when installing the database extension for Microsoft SQL Server (MSSQL).
You may encounter it if you use the MSSQL datetime type.
The nature of this quirk relates to the configuration under certain unknown circumstances. During the installation the MSSQL extension will seemingly choose to set the configuration option for the conversion of the MSSQL datetime value (
mssql.datetimeconvert) in the
php.ini to be either on or off by default.
See the bug listing here: https://bugs.php.net/bug.php?id=23611
This can prove annoying if working in a team because even with identical hardware, software (Windows XP) and versions of PHP (5.4.9) this setting seems to change.