Changeset 7257 for temp/trunk/html

Timestamp:

2006/11/02 09:17:40 (20 years ago)

Author:

kakinaka

Message:

* empty log message *

File:

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

temp/trunk/html/rss/index.php

@@ -57 +57 @@
     $col .= "     ,news_title ";                            //¿·Ãå¾ðÊ󥿥¤¥È¥ë
     $col .= "     ,news_comment ";                          //¿·Ãå¾ðÊóËÜʸ
-    $col .= "     ,to_char(news_date, 'YYYY') AS YEAR ";    //ÆüÉÕ(ǯ)
-    $col .= "     ,to_char(news_date, 'MM') AS MONTH ";     //ÆüÉÕ(·î)
-    $col .= "     ,to_char(news_date, 'DD') AS DAY ";       //ÆüÉÕ(Æü)
-    $col .= "     ,to_char(news_date, 'HH24') AS HOUR ";    //ÆüÉÕ(»þ´Ö)
-    $col .= "     ,to_char(news_date, 'MI') AS MINUTE ";    //ÆüÉÕ(ʬ)
-    $col .= "     ,to_char(news_date, 'SS') AS SECOND ";    //ÆüÉÕ(ÉÃ)
+    
+    if (DB_TYPE == "pgsql") {
+        $col .= "     ,to_char(news_date, 'YYYY') AS YEAR ";    //ÆüÉÕ(ǯ)
+        $col .= "     ,to_char(news_date, 'MM') AS MONTH ";     //ÆüÉÕ(·î)
+        $col .= "     ,to_char(news_date, 'DD') AS DAY ";       //ÆüÉÕ(Æü)
+        $col .= "     ,to_char(news_date, 'HH24') AS HOUR ";    //ÆüÉÕ(»þ´Ö)
+        $col .= "     ,to_char(news_date, 'MI') AS MINUTE ";    //ÆüÉÕ(ʬ)
+        $col .= "     ,to_char(news_date, 'SS') AS SECOND ";    //ÆüÉÕ(ÉÃ)
+    }else if (DB_TYPE == "mysql") {
+        $col .= "     ,DATE_FORMAT(news_date, '%Y') AS YEAR ";      //ÆüÉÕ(ǯ)
+        $col .= "     ,DATE_FORMAT(news_date, '%m') AS MONTH ";     //ÆüÉÕ(·î)
+        $col .= "     ,DATE_FORMAT(news_date, '%d') AS DAY ";       //ÆüÉÕ(Æü)
+        $col .= "     ,DATE_FORMAT(news_date, '%H') AS HOUR ";      //ÆüÉÕ(»þ´Ö)
+        $col .= "     ,DATE_FORMAT(news_date, '%i') AS MINUTE ";    //ÆüÉÕ(ʬ)
+        $col .= "     ,DATE_FORMAT(news_date, '%s') AS SECOND ";    //ÆüÉÕ(ÉÃ)
+    }
     $col .= "     ,news_url ";                              //¿·Ãå¾ðÊóURL
     $col .= "     ,news_select ";                           //¿·Ãå¾ðÊó¤Î¶èʬ(1:URL¡¢2:ËÜʸ)