Default Value for a Data Column

Database

Default Value for a Data Column

Hi all, I am new working with Teradata and creating a new table I am having some issues that I cannot solve. Hope you help me.

I am creating a table: 

CREATE  TABLE Example  (

"Id" BIGINT NOT NULL,

"ItemGroupAssignStartDate" DATE FORMAT 'DD-MM-YYYY',

"ItemGroupAssignEndDate" DATE FORMAT 'dd-mm-yyyy' DEFAULT '31-12-9999',

PRIMARY KEY ("Id","ItemGroupId")

);

and the system raises the next error:

Default value incompatible with type of column ITEMGROUPASSIGNENDDATE. 

the default date is valid and I have tried other values but the same.

Anyone with the solution? Thanks in advance.

1 REPLY
Enthusiast

Re: Default Value for a Data Column