php / mysql显示sql server datetime

Question

im trying to display date and time from MSSQL Server datetime table using PHP, the value from from SQL Server is datetime EX. 2012-08-20 06:23:28:214. Now i want to display it the exact result but it php displays it like this EX. Aug 20 2012 6:23AM. I Have tried to use strtotime but the milliseconds does not display or rather display :000.

Any Help is so much appreciated. Thanks in Advance.

Answer 1

Try this,

SELECT CONVERT(VARCHAR(50), CAST('2012-08-20 06:23:28:214' as DateTime), 100) 
          AS [OutPut]

-- expected output
--     Aug 20 2012 6:23AM

from the example above, I used CAST in order to convert string date into the original DateTime datatype. But in the original query, you can omit the CAST function since you've mentioned that the column is already on the DateTime data type.

SELECT CONVERT(VARCHAR(50), columnDateTime, 100)

SQLFiddle Demo

How to Format Date and DateTime in MSSQL Server