Re: 8i CASE dates
From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 3 Jul 2002 12:14:02 -0700
Message-ID: <c0d87ec0.0207031114.7b495dd4_at_posting.google.com>
Date: 3 Jul 2002 12:14:02 -0700
Message-ID: <c0d87ec0.0207031114.7b495dd4_at_posting.google.com>
>> SELECT workflow_id,
CASE
WHEN workflow_date > sysdate THEN NULL
WHEN workflow_date < TO_DATE('1800-01-01', 'YYYY-MM-DD') THEN NULL
ELSE workflow_date
END AS workflow_date
FROM bl_workflow; <<
The rule for a CASE expression in Standard SQl is that all the THEN clauses have to be of the same datatype, so the expression is of one and only one datatype. But both of yours are NULL, which should be just fine and the CASE expression should pick up the datatype of workflow_date. Sounds like a bug to me ... Received on Wed Jul 03 2002 - 21:14:02 CEST