|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #38502 mssql_fetch_Assoc result error (date type field)
Submitted: 2006-08-18 15:28 UTC Modified: 2006-08-29 01:00 UTC
From: kecso at i-trade dot hu Assigned:
Status: No Feedback Package: MSSQL related
PHP Version: 5.1.5 OS: debian
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

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

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();");

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

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


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2006-08-21 14:30 UTC]
This sounds more like a configuration problem with freetds.

Please reconfigure using --enable-msdblib.
 [2006-08-21 16:07 UTC]
oops wrong status.
 [2006-08-29 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
PHP Copyright © 2001-2023 The PHP Group
All rights reserved.
Last updated: Tue Dec 05 19:01:26 2023 UTC