Re: Null dates in a union query question

Try this one :

create or replace view x as
select 'pete' NAME, to_date(null, <date-format>) ADATE from dual
union all
select null NAME, to_date(sysdate, <date-format>) ADATE from dual;

Rajesh

PMG wrote in message <3608873E.4372F939_at_2xtreme.net>...
>Can somebody tell me how to get around this problem:
>
>create or replace view x as
> select 'pete' NAME,
> null ADATE
> from dual
>union all
> select null NAME,
> sysdate ADATE
> from dual
>
>I get ORA-01790: expression must have same datatype as corresponding
>expression in line 3 of the SQL.
>
>In other words, how do I insert a NULL into a column which will be a
>date field.
>
>TIA
>
>Pete
>
Received on Wed Sep 23 1998 - 03:07:47 CDT