PHP--PHP reads datetime in SQL Server

When PHP connects sqlserver2005, the data read is 12:00AM, that is, the format of the date is mm DD YY Hh:mmam

How to turn it into a 24-hour system, and the format shown is YY-MM-DD HH:MM:SS
Open the php.ini configuration file

Locate the following code

; On = Returns data converted to SQL Server settings ; Off = Returns values as Yyyy-mm-dd hh:mm:ss ; Mssql.datetimeconvert = on

Put "; Mssql.datetimeconvert = on "front"; " Remove and change the status to OFF

After modification, the following:

; On = Returns data converted to SQL Server settings ; off = Returns values as Yyyy-mm-dd hh:mm:ss Mssql.datetimeconvert = Off

In this way, the date is displayed as 2014-01-15 00:00:00. @[email protected]~ Finish