Compressing DATE datatype

Database
Highlighted
mzs
Enthusiast

Compressing DATE datatype

I am building a new table and my understanding is, since Terdata stores DATE datatype as integer, I need to specify a respective integer value in COMPRESS clause, i.e. to store compressed value of '2099-01-01', I would need to have COMPRESS 1990101 when defining column.  Please let me know if this is correct.

Thank you,

1 REPLY
kw
Enthusiast

Re: Compressing DATE datatype

This will work, but the table DDL will show the integer as a date value.

Easier to use : COMPRESS (DATE '2099-01-01', DATE '1900-01-01')

I think this may require the default date format on the system to be YYYY-MM-DD