#29744 [Opn->Fbk]: DARTPART function returns random results

ID: 29744 Updated by: sniper@php.net Reported By: jwhatcher at hotmail dot com -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: WINDOWS 2000 Advance Server PHP Version: 5.0.0 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2004-08-18 22:14:35] jwhatcher at hotmail dot com Description: ------------ Using in my where clause, DATEPART (dw , dt.usedate) = 1 returns random results toggling between SUNDAY AND MONDAY. Switch to DATENAME (dw , dt.usedate) = 'Sunday' and it works fine. This code worked fine in 4.2. date_table is a table with all dates between 1900 to 2050. Reproduce code: --------------- $query = mssql_query(" SELECT dt.usedate FROM date_table dt WHERE dt.usedate between '$s_reportdate' AND '$e_reportdate' AND DATEPART (dw , dt.usedate) = 1 ORDER BY DT.usedate"); Expected result: ---------------- Should return Sunday dates between range provided. Actual result: -------------- Returns seemingly random results of either a Monday or Sunday date. If I add DATEPART (dw , dt.usedate) as blah into the select clause it returns 1 every time but the dates still shift. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=29744&edit=1