sql报错。好烦躁，我理解的就是这样啊

Question

SELECT
*
FROM
wf_workitem
WHERE
instance_id IN (
SELECT
id
FROM
wf_instance
WHERE
instance_state IN ( 4, 5 )
AND process_id = 1309861313630962674
AND current_activity_names = '结束'
AND when_created BETWEEN （'2020-01-01 00:00:00' AND '2020-01-31 00:00:00'）)
最后一行报错，这是为啥啊

Answer 1

BETWEEN '2020-01-01 00:00:00' AND '2020-01-31 00:00:00'