PHP5.2.5 not displaying the correct output from MSSQL query

[pks83]

In MSSQL I am using datetime as the column type and trying to execute the below mentioned query

select time from tickets where ticket_id = '1';

when i execute the query on sql manager window it shows it correctly with seconds and milliseconds in the output like this

2008-01-30 13:58:04.000

But when i run the sql through PHP 5.2.5 it replaces the seconds and milliseconds with AM/PM
sql1="select time from tickets where ticket_id = '1' ";
$row1=mssql_query($sql1);
$res1=mssql_fetch_assoc($row1);
print_r($res1);
output comes like this

Array ( [time] => Jan 30 2008 1:52PM )

Please help on how to get the full datetime including seconds and milliseconds and not with AM/PM using PHP 5.2.5

Thanks

[rohypnol]

sql1="select `time` from tickets where ticket_id = '1' ";
 

Use backticks for "strange" column names which are also mysql functions.
Hope this helps.

[code green]

MsSql doesn't like backticks.

This is a quirk of php-mssql.
I have never needed the precision of seconds so has never worried me,
but this topic has been raised on the sql server forum.
Not sure if an explanation was found.
However you could use CONVERT

SELECT CONVERT(VARCHAR, time,113) FROM tickets where ticket_id = '1' 

I think is right. There are varitions if you Google and 113 is one of many format codes.
But be aware the data type HAS been converted to a non datetime format.
So if you want to do datetime comparisons you will need to use strtotime
[PHP]$time = strtotime($result['time'][/PHP]