Help Last_Day
680835Jan 24 2009 — edited Jan 24 2009Hello.
I have a problem in my sentence, I need extract information by range date.
My sentence is the next.
WHERE EFM='F'
AND TO_CHAR(af_dat,'yyyymmdd') BETWEEN TO_CHAR(TRUNC(ADD_MONTHS(SYSDATE,-1),'MM'),'yyyymmdd')
AND TO_CHAR(LAST_DAY(ADD_MONTHS(SYSDATE,-1),'yyyymmdd')
AND(TO_CHAR(af_tim,'HH24:MI:SS') BETWEEN '05:30:00' AND '23:59:59'
OR TO_CHAR(af_tim,'HH24:MI:SS') BETWEEN '00:00:00' AND '00:45:00')
ORDER BY AF_DAT,AF_TIM
But I have this problem:
AND TO_CHAR(LAST_DAY(ADD_MONTHS(SYSDATE,-1),'yyyymmdd')
*
ERROR at line 10:
ORA-00909: invalid number of arguments
Edited by: Lecuirre Lamochie on Jan 24, 2009 7:48 AM