Re: DEFAULT value for a DATETIME Column
Bappy wrote:
>
> I am have problem running the following statement
>
> CREATE TABLE XX
> (
> XX_ID CHAR(30) NOT NULL,
> XX_NM CHAR(30) DEFAULT 'DEMOGRAPHICS UNAVAILABLE ',
> XX_STA_DT DATETIME YEAR TO DAY DEFAULT '1997-01-23',
> XX_MAX_PMT_AMT DECIMAL(9,0) DEFAULT -1,
> XX_INCL CHAR(1) DEFAULT 'Y'
> )> ;
>
> It error's out and complains that '1997-01-23' is not in a valid
> format. I gave tried a several other format's i.e. '1997/01/23'.
> Nothing seem to work.
Bappy, try this:
XX_STA_DT DATETIME YEAR TO DAY
DEFAULT datetime ('1997-01-23') year to day,
--
-- Jake Salomon
. .
_..-'( )`-.._
./'. '||\\\\. }\\_/{ .//||` .`\\.
./'.|'.'||||\\\\|.. )o o( ..|//||||`.`|.`\\.
./'..|'.|| |||||\\`````` \\'@'/ ''''''/||||| ||.`|..`\\.
./'.||'.|||| ||||||||||||. | .|||||||||||| ||||.`||.`\\.
/'|||'.|||||| ||||||||||||{ | }|||||||||||| ||||||.`|||`\\
'.|||'.||||||| ||||||||||||{ | }|||||||||||| |||||||.`|||.`
'.||| ||||||||| |/' ``\\||`` | ''||/'' `\\| ||||||||| |||.`
|/' \\./' `\\./ \\!|\\ /|!/ \\./' `\\./ `\\|
V V V }' `\\ /' `{ V V V
\\ \\ \\ V / / /
+-----------------------------------------------------------+
| Impeccable Logic: A thought process which successfully |
| resists chicken bites |
+-----------------------------------------------------------+