Index: branches/dev/html/admin/home.php
===================================================================
--- branches/dev/html/admin/home.php	(revision 374)
+++ branches/dev/html/admin/home.php	(revision 376)
@@ -108,5 +108,5 @@
 		$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));