Index: temp/trunk/html/admin/home.php
===================================================================
--- temp/trunk/html/admin/home.php	(revision 4721)
+++ temp/trunk/html/admin/home.php	(revision 4722)
@@ -84,7 +84,14 @@
 	
 	if ( $method == 'SUM' or $method == 'COUNT'){
+	// postgresql ¤È mysql ¤È¤ÇSQL¤ò¤ï¤±¤ë
+	if (DB_TYPE == "pgsql") {
+		$sql = "SELECT ".$method."(total) FROM dtb_order
+				 WHERE del_flg = 0 AND to_char(create_date,'YYYY/MM') = ? 
+				 AND to_char(create_date,'YYYY/MM/DD') <> to_char(now(),'YYYY/MM/DD')";
+	}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) = ? 
 				 AND cast(substring(create_date,1, 10) as date) <> cast(substring(now(),1, 10) as date)";
+	}
 		$return = $conn->getOne($sql, array($month));
 	}