ここの情報は古いです。ご理解頂いた上でお取り扱いください。

Changeset 9725


Ignore:
Timestamp:
Dec 27, 2008, 4:38:09 PM (14 years ago)
Author:
kiwa
Message:

#3242:PostgreSQL8系だと日時集計にデータが反映されなかったのを修正(2.10)

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/stable-2.10.x/webapp/modules/admin/lib/db_admin.php

    r9713 r9725  
    10181018{
    10191019    if ($GLOBALS['_OPENPNE_DSN_LIST']['main']['dsn']['phptype'] == 'pgsql') {
    1020         $sql = "SELECT substr(r_datetime,1,10) as ymd , count(*) as count" .
     1020        $sql = "SELECT substr(r_datetime::text,1,10) as ymd , count(*) as count" .
    10211021            " FROM c_access_log " .
    1022             " where substr(r_datetime,1,7) = ?" .
     1022            " where substr(r_datetime::text,1,7) = ?" .
    10231023            " and ktai_flag = ? " .
    10241024            " group by ymd";
Note: See TracChangeset for help on using the changeset viewer.