Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have used two date fields as ,
LET ThisExecTime=TIMESTAMP(Now(),'MM/DD/YYYY HH:MM:SS TT');
IF(not IsNull(QvdCreateTime('$(Qvdpath)Roller.qvd'))) then
LatestTime:
LOAD max(PAT_MODIFIED_DATE) as LastExecT FROM $(Qvdpath)Roller.qvd (qvd);
let LastExecTime =TIMESTAMP(peek('LastExecT',0,'LatestTime'),'MM/DD/YYYY HH:MM:SS TT') ;
DROP Table LatestTime;
ENDIF
I am using the variables in the query as SELECT .... WHERE MODIFIED_DATE>= TO_TIMESTAMP('$(LastExecTime)') AND MODIFIED_DATE <= TO_TIMESTAMP('$(ThisExecTime)');
But I am getting an Errr as
"ORA-01843: not a valid month"
Any help on this ?
I have tried updating it as MM also .
Hi!
I'm not completey sure, but your date format seems to miss one digit for the month. Shouldn't it be MM/DD/YYYY ? Otherwise I don't see how you want to distinguish October (10) or November (11) from January (1).
Greetings
Wiley_E