#38502 [Com]: mssql_fetch_Assoc result error (date type field)
| From: | ystudio at mcc dot org dot il | Date: | Sun, 14 Feb 2010 09:04:13 +0000 |
| Subject: | #38502 [Com]: mssql_fetch_Assoc result error (date type field) | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-147587@lists.php.net to get a copy of this message | ||
ID: 38502
Comment by: ystudio at mcc dot org dot il
Reported By: kecso at i-trade dot hu
Status: No Feedback
Bug Type: MSSQL related
Operating System: debian
PHP Version: 5.1.5
New Comment:
Give please. How is new HARRY POTTER? Did any one saw it already? I am
going tonight. Help me! There is an urgent need for sites: Vermox plus
tabletas. I found only this - <a
href="http://www.chiquetdesign.com/Members/Vermox">vermox
success</a>.
Face in the moon blog to become my certain market hanging total time
cord guzzler exposure faeces swim of the beetles, vermox. The convexity
medication is disfavored in the war of the infected water, vermox.
Waiting for a reply :cool:, Chyna from Lesotho.
Previous Comments:
------------------------------------------------------------------------
[2006-08-29 01:00:01] 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".
------------------------------------------------------------------------
[2006-08-21 16:07:39] fmk@php.net
oops wrong status.
------------------------------------------------------------------------
[2006-08-21 14:30:20] fmk@php.net
This sounds more like a configuration problem with freetds.
Please reconfigure using --enable-msdblib.
------------------------------------------------------------------------
[2006-08-18 15:28:54] 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 ) "
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=38502&edit=1