Changeset 4745 for temp

Timestamp:

2006/09/14 20:00:14 (20 years ago)

Author:

kakinaka

Message:

blank

File:

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

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

@@ -144 +144 @@
 //---- Á´¥Ç¡¼¥¿¼èÆÀ
 //$sql = "SELECT *, EXTRACT(EPOCH FROM news_date) as news_date_unix FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";
-$sql = "SELECT * FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";
+$sql = "SELECT *, cast(substring(news_date,1, 10) as date) as cast_news_date  FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";
 $objPage->list_data = $conn->getAll($sql);
 $objPage->line_max = count($objPage->list_data);