Re: PHP 4.0 Bug #7097 Updated: Problems with date fields

Rob, Rob Greenhalgh wrote: > Derick, > > The error is being caused by the "php_mssql70.dll" file. > > The SQL statement when executed in any other way (outside of PHP), works > perfectly. You didn't make this clear in your report, be more descriptive please. > > > I have attached a screengrab of the error that is being generated. You should not mail this to me directly, but instead mail this to the php-dev list, or the bug report facility. > > > Regards, > > Rob > > > -----Original Message----- > > From: Bug Database [mailto:php-dev@lists.php.net] > > Sent: 09 October 2000 11:21 > > To: rob@regemc.fsnet.co.uk > > Subject: 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 > > > > > > ------------------------------------------------------------------------ > Name: error.jpg > error.jpg Type: JPEG Image (image/jpeg) > Encoding: base64 -- Derick Rethans JDI Media Solutions H.v.Tussenbroekstraat 1 6952 BL Dieren The Netherlands e-mail: d.rethans@jdimedia.nl http://www.jdimedia.nl/