php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please — but make sure to vote on the bug!
Your email address:
MUST BE VALID
Solve the problem:
16 + 6 = ?
Subscribe to this entry?

 
 [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: Thu Apr 18 13:01:27 2024 UTC