DEFAULT value for a DATETIME Column
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.
I am running this from a dbaccess session and unsing Informix Online
7.1.
Idea anyone?
Thanx.
Bappy