昨天:UNIX_TIMESTAMP(CAST(SYSDATE()AS DATE) - INTERVAL 1 DAY)
今天:UNIX_TIMESTAMP(CAST(SYSDATE()AS DATE))
例如查询大于今天0点的时间戳的sql:
"SELECT * FROM `table`" \ f" WHERE `trade_time` > UNIX_TIMESTAMP(CAST(SYSDATE()AS DATE))" \ f" AND `account` = '{self.owner.account}'"