Re: create table with DATE

I think your problem is the column named "START". Try issuing the create table after changing the column names (and remove one of the closing parenthesis).

create table phase(
phaseid VARCHAR(10),
start_date DATE,
end_date DATE);

Finnegan Calabro wrote:

> It was my understanding DATE could be used as a normal datatype, but I get
> an error with the following sql command (may or may not be because of the
> DATE command):
>
> create table phase(
> phaseid VARCHAR(10),
> start DATE,
> end DATE));
>
> Thanks!
> Finn
Received on Thu Jul 29 1999 - 11:13:46 CDT