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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: kecso at i-trade dot hu
New email:
PHP Version: OS:

 

 [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

Add a Patch

Pull Requests

Add a Pull Request

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: Fri Mar 29 15:01:28 2024 UTC