Oracle日期比较(无效标识符)
|
我有这个查询:
SELECT TO_CHAR(HON.CREATE_DT,\'DD-MM-YYYY\') as CREATE_DT,
HON.ACCOUNT_NO,(SELECT TO_CHAR(CURRENT_DATE - INTERVAL \'7\' DAY, \'DD-MM-YYYY\') FROM DUAL) AS NV
FROM medium.HONSCRIBERS HON,
medium.HONSCRIBER_TEXT pcode,
medium.ACCESS_NUMBERS accnr
WHERE
accnr.STATUS_CD = \'CU\' AND
pcode.TRADING_AS =\'7777777\'AND
HON.ACCOUNT_NO=pcode.ACCOUNT_NO AND
HON.ACCOUNT_NO=accnr.ACCOUNT_NO
它返回:
[0] => Array
(
[CREATE_DT] => 28-02-2008
[ACCOUNT_NO] => 20340322
[NV] => 20-05-2011
)
[1] => Array
(
[CREATE_DT] => 28-02-2008
[ACCOUNT_NO] => 20340322
[NV] => 20-05-2011
)
我需要比较日期CREATE_DT和NV
我的查询:
SELECT TO_CHAR(HON.CREATE_DT,\'DD-MM-YYYY\') as CREATE_DT,
HON.ACCOUNT_NO,(SELECT TO_CHAR(CURRENT_DATE - INTERVAL \'7\' DAY, \'DD-MM-YYYY\') FROM DUAL) AS NV
FROM medium.HONSCRIBERS HON,
medium.HONSCRIBER_TEXT pcode,
medium.ACCESS_NUMBERS accnr
WHERE
accnr.STATUS_CD = \'CU\' AND CREATE_DT < NV AND
pcode.TRADING_AS =\'7777777\'AND
HON.ACCOUNT_NO=pcode.ACCOUNT_NO AND
HON.ACCOUNT_NO=accnr.ACCOUNT_NO
我有这个错误:
[code] => 904
[message] => ORA-00904: \"NV\": invalid identifier
[offset] => 325
为什么他总是给我写信:\“ NV \”:无效的标识符?
感谢帮助。
没有找到相关结果
已邀请:
1 个回复
犯痪桂涛杭
(请注意,您不要在此处使用TO_CHAR,否则比较将无法正常进行)