How to create this table?

Hi! netters:

    I am trying to do this and can't.

Assume I have a table A. Table has two fields B and C. B is a varchar2(6), and C is and thing.
Now I like to create a new table D with two fields E and F. E is a varchar2(8) and F is a date, but E should equal B in fact. I try this

create table D as

    select B,
    '01-jan-1996 00:00:00' as F
    from A;

It doesn't work. First it generates Field E as a varchar2(6) instead of varchar2(8) and field F is a not a date.

How can I do this?
Thanks

David Received on Thu Apr 18 1996 - 00:00:00 CEST