Dear Mr. SEA,
You must subtract a duration of 1 DAY to the date, then your expression must look like this:
Select CurDate() – 1 Days from SysIBM.SysDummy1
The error ocurred because SQL took that one alone as numeric instead of a date type.
I had found from of another site the solution that was different but subtraction was successfull. I have checked your given query this also working.
May I have your email address please:
Thank you v.much.