Re: 8i CASE dates

71062.1056_at_compuserve.com (--CELKO--) wrote in message news:<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 ...

Null is not date, try cast it to date - to_date(null) Received on Mon Jul 08 2002 - 03:02:18 CEST