Changeset 4854 for temp/trunk/html/admin

Timestamp:

2006/09/17 14:40:39 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/contents/inquiry.php (modified) (2 diffs)

temp/trunk/html/admin/contents/inquiry.php

@@ -36 +36 @@
 
 
-
-
-
 class LC_Page {
     var $cnt_question;
@@ -76 +73 @@
 
 
-$sql = "SELECT *, to_char( create_date, 'YYYY/MM/DD' ) as disp_date FROM dtb_question WHERE del_flg = 0 ORDER BY question_id";
+$sql = "SELECT *, cast(substring(create_date, 1, 10) as date) as disp_date FROM dtb_question WHERE del_flg = 0 ORDER BY question_id";
 $result = $conn->getAll($sql);
 $objPage->list_data = $result;