Menu

#59 Date arithmetic expression logic has changed (broken?)

open
nobody
SQL (11)
5
2013-01-13
2003-01-23
Anonymous
No

Exported from Bugzilla, issue 4193.

--- Comment added on 12/20/02 4:46:52 PM ---
Nobody seems to be much inspired with my problem.

I will try to expose it more simply :

The following code is not supported with FF2.12
(and was supported with FF2.10) :

Select * from Table
where RecDate < (Current_date-30)

The following workaround is OK :

Select * from Table
where (RecDate+30) < Current_date

I am suspecting that compare operations do not support anymore
an expresison for the right side's member.

Thanks for support.

--
Best regards,

Emmanuel Barache
HotWare
ebarache@hotware.fr

Discussion


Log in to post a comment.

Monday.com Logo