Changeset 374

Timestamp:

2007/02/26 18:28:42 (17 years ago)

Author:

inoue

Message:

フォーラム通りに対応

File:

• branches/dev/html/admin/home.php (modified) (1 diff)

branches/dev/html/admin/home.php

@@ -107 +107 @@
     }else if (DB_TYPE == "mysql") {
         $sql = "SELECT ".$method."(total) FROM dtb_order
-                 WHERE del_flg = 0 AND cast(substring(create_date,1,7) as date) = ? 
+                 WHERE del_flg = 0 AND date_format(create_date, '%Y/%m') = ? 
                  AND cast(substring(create_date,1, 10) as date) <> cast(substring(now(),1, 10) as date)";
     }