\n SYSDATE BETWEEN start_date AND NVL(end_date, TO_DATE('31-DEC-2999'))\nBut it would then have a Y3K problem :-)
Some systems have "infinity" constants for this kind of thing.
risky use of Oracle SYSDATE?
- (tablizer)
- (11)
- Aug. 4, 2004, 07:45:50 PM EDT
Hmm. Order of evaluation
- (broomberg)
- Aug. 4, 2004, 08:15:43 PM EDT
If only the date matters...
- (admin)
- (5)
- Aug. 4, 2004, 09:31:53 PM EDT
Still could cross over
-NT
- (broomberg)
- (4)
- Aug. 4, 2004, 10:27:10 PM EDT
Unless you change the logic
- (admin)
- (3)
- Aug. 4, 2004, 11:10:14 PM EDT
sysdate wrapper - nice touch
- (broomberg)
- (1)
- Aug. 5, 2004, 12:03:50 AM EDT
Guideline doc for DML wrappers:
- (admin)
- Aug. 5, 2004, 12:06:53 AM EDT
Re: Unless you change the logic
- (tablizer)
- Aug. 7, 2004, 05:14:31 AM EDT
Another thought
- (admin)
- Aug. 4, 2004, 11:25:22 PM EDT
It would surprise me if the SYSDATE wasn't in a closure
- (ChrisR)
- (2)
- Aug. 4, 2004, 11:39:40 PM EDT
Brief testing says this might be correct.
- (admin)
- (1)
- Aug. 5, 2004, 12:01:23 AM EDT
FWIW
- (ChrisR)
- Aug. 5, 2004, 12:35:23 AM EDT
