PHP 4.0 Bug #7483: Cannot retrieve whole date out of a datefield
| From: | thargoid at gmx dot net | Date: | Thu, 26 Oct 2000 16:14:26 +0000 |
| Subject: | PHP 4.0 Bug #7483: Cannot retrieve whole date out of a datefield | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-36079@lists.php.net to get a copy of this message | ||
From: thargoid@gmx.net
Operating system: Win NT4 SP6a
PHP version: 4.0.2
PHP Bug Type: MSSQL related
Bug description: Cannot retrieve whole date out of a datefield
If I want to read out a datefield of MSSQL7, the script won't stop is the fieldtype is
"smalldatetime" and is retrieving the first 4 chars of the date.... in english format (d
mmm). If I request another php page (and didn't aborted the loading), the IIS4 freezes and
won't answering anymore requests.
if the fieldtype is "datetime", it will retrieve the first 8 characters, i.e. if the DB
field contains 1978-06-15, it will retrieve "15 Jun 1" and nothing more.
plz help me, I lost DAYS in examining this problem... and still without success.
I read the field via normal mssql_result or by fetching the row.. no matter the same result :-(
my environment:
a standart php4.0.2 w32 installation with, mssql7 support enabled, IIS4, MSSQL7 SP2, winNT 4 SP 6a
--
Edit Bug report at: http://bugs.php.net/?id=7483&edit=1