You could just use artithmetics here: where ctime >= (unix_timestamp(current_date) - day1 * 60 * 60 * 24) * 1000 and ctime ... ... <看更多>

The below results are from MariaDB, but I assume it's the same with MySQL. SET time_zone = 'SYSTEM'; SELECT FROM_UNIXTIME(0), NOW(); + ... ... <看更多>

UNIX_TIMESTAMP() 產生UNIX時間戳記. FROM_UNIXTIME() 轉一般時間標記(xxxx-xx-xx oo:oo:oo) ... <看更多>