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