Changeset 5285 for temp/trunk/html/admin

Timestamp:

2006/09/20 19:40:56 (20 years ago)

Author:

kakinaka

Message:

blank

File:

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

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

@@ -71 +71 @@
                         17 => array("sql" => "CASE WHEN sex = 1 THEN 'ÃËÀ­' ELSE '½÷À­' END AS sex", "csv" => "sex", "header" => "À­ÊÌ"),
                         18 => array("sql" => "job", "csv" => "job", "header" => "¿¦¶È"),
-                        19 => array("sql" => "to_char(birth, 'YYYYǯMM·îDDÆü') AS birth", "csv" => "birth", "header" => "ÃÂÀ¸Æü"),
-                        20 => array("sql" => "to_char(first_buy_date, 'YYYYǯMM·îDDÆüHH24:MI') AS first_buy_date", "csv" => "first_buy_date", "header" => "½é²ó¹ØÆþÆü"),
-                        21 => array("sql" => "to_char(last_buy_date, 'YYYYǯMM·îDDÆüHH24:MI') AS last_buy_date", "csv" => "last_buy_date", "header" => "ºÇ½ª¹ØÆþÆü"),
+                        19 => array("sql" => "cast(birth as date) AS birth", "csv" => "birth", "header" => "ÃÂÀ¸Æü"),
+                        20 => array("sql" => "cast(first_buy_date as date) AS first_buy_date", "csv" => "first_buy_date", "header" => "½é²ó¹ØÆþÆü"),
+                        21 => array("sql" => "cast(last_buy_date as date) AS last_buy_date", "csv" => "last_buy_date", "header" => "ºÇ½ª¹ØÆþÆü"),
                         22 => array("sql" => "buy_times", "csv" => "buy_times", "header" => "¹ØÆþ²ó¿ô"),
                         23 => array("sql" => "point", "csv" => "point", "header" => "¥Ý¥¤¥ó¥È»Ä¹â"),
                         24 => array("sql" => "note", "csv" => "note", "header" => "È÷¹Í"),
-                        25 => array("sql" => "to_char(create_date, 'YYYYǯMM·îDDÆüHH24:MI') AS create_date", "csv" => "create_date", "header" => "ÅÐÏ¿Æü"),
-                        26 => array("sql" => "to_char(update_date, 'YYYYǯMM·îDDÆüHH24:MI') AS update_date", "csv" => "update_date", "header" => "¹¹¿·Æü")
+                        25 => array("sql" => "cast(create_date as date) AS create_date", "csv" => "create_date", "header" => "ÅÐÏ¿Æü"),
+                        26 => array("sql" => "cast(update_date as date) AS update_date", "csv" => "update_date", "header" => "¹¹¿·Æü")
                     );