Changeset 4848 for temp/trunk/html/admin/mail/template.php

Timestamp:

2006/09/17 14:12:26 (20 years ago)

Author:

kakinaka

Message:

blank

File:

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

temp/trunk/html/admin/mail/template.php

@@ -41 +41 @@
 
 
-$sql = "SELECT *, to_char(create_date, 'YYYY/MM/DD HH24:MI') as disp_date FROM dtb_mailmaga_template WHERE del_flg = 0 ORDER BY create_date DESC";
+$sql = "SELECT *, (substring(create_date, 1, 19)) as disp_date FROM dtb_mailmaga_template WHERE del_flg = 0 ORDER BY create_date DESC";
 $objPage->list_data = $list_data = $conn->getAll($sql);
 $objPage->arrMagazineType = $arrMagazineTypeAll;