Changeset 4670 for temp/trunk/html

Timestamp:

2006/09/13 10:54:04 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/home.php (modified) (1 diff)

temp/trunk/html/admin/home.php

@@ -136 +136 @@
     $col.= "(SELECT det.product_name FROM dtb_order_detail AS det WHERE ord.order_id = det.order_id LIMIT 1) AS product_name, ";
     $col.= "(SELECT pay.payment_method FROM dtb_payment AS pay WHERE ord.payment_id = pay.payment_id) AS payment_method, "; 
-    $col.= "to_char(create_date, 'YYYY/MM/DD HH24:MI') AS create_date";
+//  $col.= "to_char(create_date, 'YYYY/MM/DD HH24:MI') AS create_date";
+    $col.= "cast(create_date as date) AS create_date";
     $from = "dtb_order AS ord";
     $where = "del_flg = 0";