MSSQL not showing seconds even after using datetime as the column type

[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 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);

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

Thanks

[ck9663]

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 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);

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

Thanks

if it's showing properly in SQL and not in PHP, that would you have to check how you access and/or display your field in PHP, not in SQL

-- ck

[pks83]

if it's showing properly in SQL and not in PHP, that would you have to check how you access and/or display your field in PHP, not in SQL

-- ck

But i am jus giving a print_r command to display the array value not fetching it in any field.

[ck9663]

But i am jus giving a print_r command to display the array value not fetching it in any field.

sorry but that would be a PHP issue, not SQL-Server. have you tried asking the experts in PHP forum?

-- ck

[pks83]

sorry but that would be a PHP issue, not SQL-Server. have you tried asking the experts in PHP forum?

-- ck

Thanks for the inputs ck i will post the question over there also now