Changeset 4897

Timestamp:

2006/09/17 19:06:37 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/data/lib/slib.php (modified) (1 diff)

temp/trunk/data/lib/slib.php

@@ -1009 +1009 @@
     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 = ? )";
         //ÅÐÏ¿(¹¹¿·)ÆüÉÕ½ç