#38502 [Opn->NoF]: mssql_fetch_Assoc result error (date type field)

From: Date: Mon, 21 Aug 2006 14:30:21 +0000
Subject: #38502 [Opn->NoF]: mssql_fetch_Assoc result error (date type field)
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-101071@lists.php.net to get a copy of this message 
 ID:               38502
 Updated by:       fmk@php.net
 Reported By:      kecso at i-trade dot hu
-Status:           Open
+Status:           No Feedback
 Bug Type:         MSSQL related
 Operating System: debian
 PHP Version:      5.1.5
 New Comment:

This sounds more like a configuration problem with freetds.

Please reconfigure using --enable-msdblib.


Previous Comments:
------------------------------------------------------------------------

[2006-08-18 15:28:54] kecso at i-trade dot hu

Description:
------------
Hi!

MYSQL version: MySQL 5.0.22-Debian_1.dotdeb.1-log
PHP version: PHP Version 5.0.5-Debian-0.8~sarge1 (Debian GNU/Linux)

After fetching data, the date was 1 month lesser than the current
system date.

Tested with SQL Query Analyzer the date was correct.

If converted the date, was correct... 
"SELECT convert(varchar(50), getdate(), 102)"

Best regards: Kecso


Reproduce code:
---------------
$r = mssql_query("SELECT getDate();");
print_r(mssql_fetch_Assoc($r));

Expected result:
----------------
" Array ( [computed] => 2006-08-18 17:07:05 ) "

Actual result:
--------------
" Array ( [computed] => 2006-07-18 17:07:05 ) "


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=38502&edit=1

Thread (4 messages)

« previous php.bugs (#101071) next »