Re: create table with DATE

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Thu, 29 Jul 1999 17:06:57 GMT
Message-ID: <37a489d3.102447201@inet16.us.oracle.com>

On Thu, 29 Jul 1999 11:54:07 -0400, "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));

The word START is a reserved word so it can not be used as column name.

chris.

>
>Thanks!
>Finn
>

--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jul 29 1999 - 12:06:57 CDT