Index: /temp/trunk/data/lib/slib.php
===================================================================
--- /temp/trunk/data/lib/slib.php	(revision 4896)
+++ /temp/trunk/data/lib/slib.php	(revision 4897)
@@ -1009,6 +1009,7 @@
 	if(sfIsInt($product_id)) {
 		$objQuery = new SC_Query();
-		$where = "to_char(now(),'YYYY/MM/DD/HH24') >= to_char(start_date,'YYYY/MM/DD/HH24') AND ";
-		$where .= "to_char(now(),'YYYY/MM/DD/HH24') < to_char(end_date,'YYYY/MM/DD/HH24') AND ";
+	    $where = "now() >= cast(start_date as date) AND ";
+	    $where .= "now() < cast(end_date as date) AND ";
+		
 		$where .= "del_flg = 0 AND campaign_id IN (SELECT campaign_id FROM dtb_campaign_detail where product_id = ? )";
 		//ÅÐÏ¿(¹¹¿·)ÆüÉÕ½ç