From: Victor B. <vb...@us...> - 2004-05-10 13:04:05
|
Update of /cvsroot/mantisbt/mantisbt/core In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv15439/core Modified Files: database_api.php Log Message: M core/database_api.php - date diff takes 'start date' subtract end date. This commit is done on behalf of paulr. Index: database_api.php =================================================================== RCS file: /cvsroot/mantisbt/mantisbt/core/database_api.php,v retrieving revision 1.27 retrieving revision 1.28 diff -u -d -r1.27 -r1.28 --- database_api.php 9 May 2004 19:28:00 -0000 1.27 +++ database_api.php 10 May 2004 13:03:55 -0000 1.28 @@ -317,7 +317,7 @@ switch( $t_db_type ) { case 'mssql': - return "(DATEDIFF(day, $p_date1,$p_date2) ". $p_limitstring . ")"; + return "(DATEDIFF(day, $p_date2, $p_date1) ". $p_limitstring . ")"; case 'mysql': return "(TO_DAYS($p_date1) - TO_DAYS($p_date2) ". $p_limitstring . ")"; |