sql:
SELECT (
To_date(To_char(Trunc(SYSDATE), 'yyyy/mm/dd hh24:mi:ss'), 'yyyy/mm/dd hh24:mi:ss') + interval '7' hour
) as "now",
(
To_date(To_char(Trunc(SYSDATE -1), 'yyyy/mm/dd hh24:mi:ss'), 'yyyy/mm/dd hh24:mi:ss') + interval '7' hour
) as "e"
FROM dual
结果: