PHP 4.0 Bug #7097 Updated: Problems with date fields

ID: 7097 Updated by: derick Reported By: rob@regemc.fsnet.co.uk Status: Closed Bug Type: MSSQL related Assigned To: Comments: SQL is not a part of PHP, the problem must be found in MySQL for this. Previous Comments: --------------------------------------------------------------------------- [2000-10-09 06:15:37] rob@regemc.fsnet.co.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. --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=7097