Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*incompatible\s+operator\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*incompatible\s+operator\s*$/: 5 ]

Total 5 documents matching your query.

1. incompatible operator (score: 1): Author: Joni Moyer <joni.moyer AT HIGHMARK DOT COM>; Date: Tue, 5 Jul 2005 11:09:43 -0400; Hello Everyone! I think I had this issue before, but I can't seem to find the solution to it. Any suggestions as to why this will not work? I am trying to get that listing pinpointed to reporting eac; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2005-07/msg00045.html (11,441 bytes)
2. Re: incompatible operator (score: 1): Author: PAC Brion Arnaud <Arnaud.Brion AT PANALPINA DOT COM>; Date: Tue, 5 Jul 2005 17:19:41 +0200; Joni, Try something like : where days(current_timestamp)-days(pending_date) =1 This should work ! Cheers. Arnaud ** ** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42,; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2005-07/msg00048.html (12,299 bytes)
3. Re: incompatible operator (score: 1): Author: Andrew Raibeck <storman AT US.IBM DOT COM>; Date: Tue, 5 Jul 2005 08:40:23 -0700; I think the problem is that you are mixing "date" data with "timestamp" data (the latter includes date and time). Try changing this: ... and date(pending_date) < (current_timestamp - 1 day) and ... t; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2005-07/msg00050.html (12,593 bytes)
4. Re: incompatible operator (score: 1): Author: "Warren, Matthew (Retail)" <Matthew.Warren AT POWERGEN.CO DOT UK>; Date: Tue, 5 Jul 2005 16:38:50 +0100; Playing with this, & my SQL knowledge not being so good I have a question. Why does this; pending_date < current_timestamp - 1 day return the same as this pending_date < (current_timestamp - 1 day) B; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2005-07/msg00051.html (13,469 bytes)
5. Re: incompatible operator (score: 1): Author: "Warren, Matthew (Retail)" <Matthew.Warren AT POWERGEN.CO DOT UK>; Date: Tue, 5 Jul 2005 16:41:44 +0100; This will also work, date(pending_date) < date(current_timestamp - 1 day) Computer says 'No'.. Hello Everyone! I think I had this issue before, but I can't seem to find the solution to it. Any sugges; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2005-07/msg00052.html (13,012 bytes)

Current List: 1 - 5
Page: [1]