Re: MS-SQL date format problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux