Hmm, what fieldtype is it in the DB? We have a bunch of DATETIME type's, and using a standard query it works just fine, returning in the proper format, without ODBC. The only difference is we use mssql_fetch_array instead of fetch_row. On Mon, 2003-05-12 at 09:12, Peter Misun wrote: > Does anybody know, how to set date-time format for mssql_* functions? > > For example, after retrieving data by function mssql_fetch_row, the value returned was "22 XII 1975 0:00 > " (which is midnight of 22nd December 1975) > As you see, value "XII" (for month) is really unusable > > where to set that date format? > > with odbc functions it returns "1975-12-22 00:00:00.000", wha is really clear > > 5o -- Adam Voigt (adam@cryptocomm.com) Linux/Unix Network Administrator The Cryptocomm Group -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php