|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Bug Type:
From: rob at regemc dot fsnet dot co dot uk
New email:
PHP Version: OS:


 [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.


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2000-10-09 06:20 UTC]
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

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]
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: Fri Jun 21 18:01:31 2024 UTC