Tags for YYYYMMDD
Create a table with a date column that has a default lenght (8)
Hi All! We can not create a table adding a column DATE that has lenght(8) using FORMAT (YYYYMMDD) and default value '00010101'. Nir 20010101 nor 20000101 default values are not working. currently We are running the DDL USING: FEC_INFORMACION        DATE           FORMAT 'YYYYMMDD' NOT NULL DEFAULT DATE '0001-01-01'
date format default value create table YYYYMMDD