在ck数据库中,我执行了SQL
SELECT POSTED_DATE, parseDateTimeBestEffort(POSTED_DATE), uuid
FROM table_01
WHERE 1 = 1
AND `uuid` = 'dff5aac8-0fb1-41a3-8f34-7d2bd3f0ce7c'
返回了
但是当我执行
SELECT POSTED_DATE
FROM (
SELECT uuid,POSTED_DATE ,parseDateTimeBestEffort(POSTED_DATE)
FROM table_01
WHERE `uuid` = 'dff5aac8-0fb1-41a3-8f34-7d2bd3f0ce7c'
)
WHERE toDate(parseDateTimeBestEffort(POSTED_DATE)) > toDate(toStartOfMonth(today() - INTERVAL 1 DAY));
就会报错
感觉问题就在parseDateTimeBestEffort(POSTED_DATE))中,但是在前面的数据中又可以正常解析,望大神解惑