17,377
社区成员
发帖
与我相关
我的任务
分享
WITH aa
AS (SELECT TO_DATE ('2019-08-02 07:29:59', 'yyyy-mm-dd hh24:mi:ss') rq
FROM DUAL
UNION ALL
SELECT TO_DATE ('2019-08-02 07:30:01', 'yyyy-mm-dd hh24:mi:ss') rq
FROM DUAL)
SELECT CASE
WHEN TO_CHAR (rq, 'hh24miss') < '073000'
THEN
TRUNC (rq - 1)
ELSE
TRUNC (rq)
END
new_rq
FROM aa