Time format: seconds are not displayed from MSSQL

Hi, I don't know where is problem, but when I connect to MSSQL server and I try get a date which is defined as datetime, when I set frm='yyyy-mm-dd hh:nn:ss' I'll get time without seconds. Only :00 is displayed.
But wwhen I run same SQL question in Enterprice architect, I'll get correct format with seconds and miliseconds.

Sorry i found problem in PHP. You must set
for connection with MSSQL server.

Hi,

A DateTime value in MySQL is retrurned as a string in PHP with the following format :
Using the mssql library : "2006-10-27 09:46:09.210"
Using the odbc library : "27/oct./2006 9:51" (french configuration)

For a SmallDateTime value,
the mssql library returns : "2006-10-27 09:46:09"

The problem is that PHP may not convert such strings as expected (TBS uses strtotime() for parameter "frm").
The solution I have found for my work is to use CONVERT() in my SQL statement when I need to display dates.
It returns a string like "2006-10-27 09:46:09" which is always good for PHP.
I also use It returns a string like "20061027" which is always good for both PHP and MySQL.