Changeset 4867 for temp/trunk/html

Timestamp:

2006/09/17 16:49:46 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/frontparts/bloc/news.php (modified) (1 diff)

temp/trunk/html/frontparts/bloc/news.php

@@ -19 +19 @@
 function lfGetNews(){
     $conn = new SC_DBConn();
-    $sql = "SELECT *, to_char(news_date, 'YYYY/MM/DD') as news_date_disp FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";
+    $sql = "SELECT *, cast(substring(news_date,1,10) as date) as news_date_disp FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";
     $list_data = $conn->getAll($sql);
     return $list_data;