Re: MS-SQL date format problem

it's just "datetime" in MSSQL7 (not "smalldatetime") - more precisely, it has 'length'=8 and 'precision'=0 i tried also mssql_fetch_array, but it was the same any other help? 5o Adam Voigt wrote: > 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 -- Mgr. Peter Misun MicroStep-MIS, Ilkovicova 3, 841 04 Bratislava, Slovakia tel: +421/ 2/ 602 00 127, 111, fax: +421/ 2/ 602 00 180