Strange problem with '+' symbols in db select

stevenlong

I've no idea why this is happening, but '+' symbols are being stripped from my query when it's executed on the database.

In my where clause I had;

some_date <= sysdate+1

This looked fine in Sahi's parsed script and in the queue, but when looking in the Sahi console to see what was executed on the database it said;

some_date <= sysdate 1

I got around it by using;

some_date <= sysdate-(-1)

but just wondered if anyone else has had this sort of problem and if anyone knows why it happens.

Cheers.
Steve.