Re: DEFAULT value for a DATETIME Column
Hi,
here you are:
XX_STA_DT DATETIME YEAR TO DAY
DEFAULT DATETIME( 1997-01-23 ) YEAR TO DAY,
(see Literal DATETIME, Syntax)
Best regards,
Julian.
23-Jan-97 22:22 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.
>
> I am running this from a dbaccess session and unsing Informix Online
> 7.1.
>
> Idea anyone?
>
> Thanx.
>
> Bappy
>
--
Julian Zalutsky MIS, JSCB "Belcombank"
julian@martcom.belpak.brest.by Brest, Republic of Belarus