12 lines
528 B
Plaintext
12 lines
528 B
Plaintext
<?php
|
|
namespace SYSTEM\SQL;
|
|
class SYS_LOG_MONTH extends \SYSTEM\DB\QP {
|
|
public static function get_class(){return \get_class();}
|
|
public static function pgsql(){return
|
|
'SELECT * FROM '.\SYSTEM\SQL\system_log::NAME_PG.' WHERE EXTRACT(MONTH FROM time)::INTEGER = $1 AND EXTRACT(YEAR FROM time)::INTEGER = $2 ORDER BY time ASC LIMIT 10000;';
|
|
}
|
|
public static function mysql(){return
|
|
'SELECT * FROM '.\SYSTEM\SQL\system_log::NAME_MYS.' WHERE MONTH(time) = ? AND YEAR(time) = ? ORDER BY time ASC LIMIT 10000;';
|
|
}
|
|
}
|