yzm7X7rf0030840(提问者)根据 WHERE CREATION_TIME 字段去进行判断，CREATION_TIME有三个值 ， 当天八点，当天十二点，当天四点，CREATION_TIME 等于当天八点 ，CREATION_TIME 等于当天十二点， CREATION_TIME等于当天四点，按照先八点，在十二点，最后是四点去执行,要怎么修改
SELECT
*
FROM aaa a
and A.TIME_SLOT =(
CASE
WHEN substr(to_char(A.CREATION_TIME ,\'yyyy-mm-dd HH24\'),1,13) = CONCAT(\'2023-04-14 \',\'08\') THEN \'早上\'
WHEN substr(to_char(A.CREATION_TIME ,\'yyyy-mm-dd HH24\'),1,13) = CONCAT(\'2023-04-14 \',\'12\') THEN \'上午\'
WHEN substr(to_char(A.CREATION_TIME ,\'yyyy-mm-dd HH24\'),1,13) = CONCAT(\'2023-04-14 \',\'16\') THEN \'下午\'
END
)
1min目标场景问卷
立即参与
