If only the date matters...

Post #167,538 by admin 8/4/04 9:31:53 PM Reply	If only the date matters... use TRUNC(SYSDATE). Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #167,542 by broomberg 8/4/04 10:27:10 PM Reply	Still could cross over
Post #167,546 by admin 8/4/04 11:06:54 PM 8/4/04 11:10:14 PM Reply	Unless you change the logic to include a +1, as you indicated. If you use a trunc, however, you always know where you stand. Of course, you might need to add a functional index to the table as well. Personally, I might throw sysdate into a variable and use that instead, depending on where this is being used. Side note: in our system, we have a function to wrap sysdate. This lets us actually set sysdate to whatever we want for testing purposes. We're also guaranteed to always get the exact same date within the same session call. This doesn't work for sessions that aren't ended between calls, of course. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..." Edited by admin Aug. 4, 2004, 11:10:14 PM EDT Expand All History
Post #167,551 by broomberg 8/5/04 12:03:50 AM Reply	sysdate wrapper - nice touch I'm about to embark on a fullfillment tracking / automation system. Will need well controlled Oracle table updates, etc. Been YEARS since I've written anything like this. Would you happen to have a guideline doc handy for for things such at update wrappers, etc?
Post #167,552 by admin 8/5/04 12:05:40 AM 8/5/04 12:06:53 AM Reply	Guideline doc for DML wrappers: "Use them." :-) Flippancy aside, we've had reasonably good results with using object wrappers for table DML. Apparently there's such a thing as "upsert" now, which should come in handy. Depends on the situation as to what you need to do. I'd suggest the Feuerstein books if you don't have them. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..." Edited by admin Aug. 5, 2004, 12:06:53 AM EDT Expand All History
Post #168,059 by tablizer 8/7/04 5:12:05 AM 8/7/04 5:14:31 AM Reply	Re: Unless you change the logic My suggested fix was something like: \n SYSDATE BETWEEN start_date AND NVL(end_date, TO_DATE('31-DEC-2999'))\n But it would then have a Y3K problem :-) Some systems have "infinity" constants for this kind of thing. ________________ oop.ismad.com Edited by tablizer Aug. 7, 2004, 05:14:31 AM EDT Expand All History

Welcome to IWETHEY!