Lines Matching refs:TIME

234             $TIME = "strftime('%H', DATETIME(P.dt, '$this->tz'))";
236             $TIME = "DATE(DATETIME(P.dt, '$this->tz'))";
242         $sql = "SELECT $TIME as time,
250               GROUP BY $TIME
268             $TIME = "strftime('%H', DATETIME(dt, '$this->tz'))";
270             $TIME = "DATE(DATETIME(dt, '$this->tz'))";
277             $sql = "SELECT $TIME as time,
282                   GROUP BY $TIME
301 …    $TIME = "strftime('%Y', DATETIME(dt, '$this->tz')), strftime('%W', DATETIME(dt, '$this->tz'))";
303             $TIME = "strftime('%Y-%m', DATETIME(dt, '$this->tz'))";
305             $TIME = "strftime('%d-%m', DATETIME(dt, '$this->tz'))";
313         $sql = "SELECT $TIME as time,
318                   GROUP BY $TIME
319                   ORDER BY $TIME";