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 Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If 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

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: Sat Dec 21 12:01:31 2024 UTC