oracle选择查询中缺少右括号问题

Question

我在oracle中有以下简单的select查询。

SELECT
HN.HAND_PERSON_NOTIFICATIONS_GUID,      
HN.NOTIFICATION_TEXT,
HN.NOTIFICATION_TYPE,
HN.NOTIFICATION_DATE,    
TO_CHAR(HN.CREATE_DATE,'dd-MM-yyyy') AS CREATE_DATE,
TO_CHAR(HN.CHANGE_DATE,'dd-MM-yyyy') AS CHANGE_DATE,
TO_CHAR(HN.REG_DATE,'dd-MM-yyyy') AS REG_DATE,
LU.INIT AS INIT,
IX.PNR AS CPR,
IX.NAVN AS FULLNAME
FROM HAND_PERSON_NOTIFICATIONS HN, LM_USER LU, HAND_PERSON_INFO HI, INDIVID_X IX
WHERE HN.HAND_PERSON_INFO_GUID = HI.HAND_PERSON_INFO_GUID
AND HN.REG_USER_GUID = LU.LM_USER_GUID
AND HI.CPR = IX.PNR  
AND HI.HAND_PERSON_INFO_GUID = 'd274579c-3132-485e-a3ea-d5b540c19faf' 
AND HN.NOTIFICATION_TYPE = 'fsfsfs' 
AND TO_DATE(HN.NOTIFICATION_DATE, 'DD-MM-YYYY') BETWEEN TO_DATE('21-07-2022', 'DD-MM-YYYY') AND TO_DATE('21-07-2022, 'DD-MM-YYYY') 
ORDER BY HN.CREATE_DATE DESC

但是当我运行查询时，我得到以下错误：

ORA-00907：manglende højre父母00907.00000-"；缺少右括号"；*原因：
*措施：第18行第119列错误

请注意，HN.NOTIFICATION_DATE的列类型为DATE。有人能告诉我问题出在哪里吗？

Answer 1

AND TO_DATE('21-07-2022 ,, 'DD-MM-YYYY')上缺少右括号

尝试以下查询：

SELECT
HN.HAND_PERSON_NOTIFICATIONS_GUID,      
HN.NOTIFICATION_TEXT,
HN.NOTIFICATION_TYPE,
HN.NOTIFICATION_DATE,    
TO_CHAR(HN.CREATE_DATE,'dd-MM-yyyy') AS CREATE_DATE,
TO_CHAR(HN.CHANGE_DATE,'dd-MM-yyyy') AS CHANGE_DATE,
TO_CHAR(HN.REG_DATE,'dd-MM-yyyy') AS REG_DATE,
LU.INIT AS INIT,
IX.PNR AS CPR,
IX.NAVN AS FULLNAME
FROM HAND_PERSON_NOTIFICATIONS HN, LM_USER LU, HAND_PERSON_INFO HI, INDIVID_X IX
WHERE HN.HAND_PERSON_INFO_GUID = HI.HAND_PERSON_INFO_GUID
AND HN.REG_USER_GUID = LU.LM_USER_GUID
AND HI.CPR = IX.PNR  
AND HI.HAND_PERSON_INFO_GUID = 'd274579c-3132-485e-a3ea-d5b540c19faf' 
AND HN.NOTIFICATION_TYPE = 'fsfsfs' 
AND TO_DATE(HN.NOTIFICATION_DATE, 'DD-MM-YYYY') BETWEEN TO_DATE('21-07-2022', 'DD-MM-YYYY') AND TO_DATE('21-07-2022', 'DD-MM-YYYY') 
ORDER BY HN.CREATE_DATE DESC