php.net |  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
 [2006-08-18 15:28 UTC] 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 ) "

Patches

Pull Requests

History

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

Please reconfigure using --enable-msdblib.
 [2006-08-21 16:07 UTC] fmk@php.net
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-2024 The PHP Group
All rights reserved.
Last updated: Tue Oct 15 19:01:26 2024 UTC