- 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)
This search system is powered by
Namazu