Changeset 376

Timestamp:

2007/02/26 18:41:48 (16 years ago)

Author:

inoue

Message:

他のcastもdate_formatに統一

File:

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

branches/dev/html/admin/home.php

@@ -108 +108 @@
         $sql = "SELECT ".$method."(total) FROM dtb_order
                  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)";
+                 AND date_format(create_date, '%Y/%m/%d') <> date_format(now(), '%Y/%m/%d')";
     }
         $return = $conn->getOne($sql, array($month));