PHP 4.0 Bug #7097: Problems with date fields

From: rob@regemc.fsnet.co.uk Operating system: Windows 2000 Server PHP version: 4.0.2 PHP Bug Type: MSSQL related Bug description: Problems with date fields 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. -- Edit Bug report at: http://bugs.php.net/?id=7097&edit=1