17,382
社区成员




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