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

go to bug id or search bugs for

Bug #7097 Problems with date fields
Submitted: 2000-10-09 06:15 UTC Modified: 2000-10-20 17:05 UTC
From: rob at regemc dot fsnet dot co dot uk Assigned:
Status: Closed Package: MSSQL related
PHP Version: 4.0.2 OS: Windows 2000 Server
Private report: No CVE-ID: None
View Developer Edit
 [2000-10-09 06:15 UTC] rob at regemc dot fsnet dot co dot uk 
When executing a MIN or MAX on a date field, it gives an error.

I have reinstalled both the operating system and PHP (not due to PHP!), and I am still getting the same error.

I have got around it temporarily by using the following...

*****************************************
MIN(rtrim(convert(char,Logs.DateAndTime,112)) + ' ' + rtrim(convert(char,Logs.DateAndTime,8))) AS LoDate
*****************************************

I have to convert it to an ISO-formatted date so that it will return me the correct results.  This will produce overhead.  When this gets fixed, I will be really happy.

Please feel free to contact me if you require more information.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-10-09 06:20 UTC] derick@php.net 
SQL is not a part of PHP, the problem must be found in MySQL for this.
 [2000-10-09 07:04 UTC] rob at regemc dot fsnet dot co dot uk 
The SQL statement when executed in any other way (outside of PHP, ie. MS SQL Query Analyser), works perfectly.

I receive a messagebox on the server, that states this...

**************************************************
php.exe - Application Error

The instruction at "0x77fc90cd" referenced memory
at "0x00080101".  The memory could not be
"written".

Click on OK to terminate the program
Click on CANCEL to debug the program
**************************************************

I have Visual C++ 6 installed on my system.  Possibly the reason why it asks me to debug.

I think the problem lies in the "php_mssql70.dll" library.
 [2000-10-20 17:05 UTC] fmk@php.net 
Datetime columns was truncated. This has been fixed in CVS. The changes will be availavle from php 4.0.4

Please email me if you want my copy of php_mssql20.dll
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Dec 26 23:01:28 2024 UTC