Re: create table with DATE

From: Ivan Muravyev <ivanm_at_mastech.com>
Date: Tue, 24 Aug 1999 13:51:17 -0400
Message-ID: <37C2DB95.AF3C92D1@mastech.com>

"start" and "end" are reserved words. If you can - change column names or, if you want, use double quotes in column naming (later you'll hate yourself for this decision :-)

Jaan

> "Finnegan Calabro" <fcalabro_at_aisvt.bfg.com> 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));
> >
Received on Tue Aug 24 1999 - 12:51:17 CDT