SELECT (CAST((CAST(SYSDATE()AS DATE) + INTERVAL 1 DAY)AS DATETIME) - INTERVAL 1 HOUR - INTERVAL 1 SECOND) todayPoint ,(CAST((CAST(SYSDATE()AS DATE) )AS DATETIME) - INTERVAL 1 HOUR) yesterdayPoint
SELECT (CAST((CAST(SYSDATE()AS DATE) + INTERVAL 1 DAY)AS DATETIME) - INTERVAL 1 HOUR - INTERVAL 1 SECOND) todayPoint ,(CAST((CAST(SYSDATE()AS DATE) )AS DATETIME) - INTERVAL 1 HOUR) yesterdayPoint