compress Timestamp(6)

UDA
Enthusiast

compress Timestamp(6)

Is there a way to compress timestamp(6) field.
we have a exp_ts field that gets a default value of 9999-12-31 00:00:00.000000 I want to compress this field is this possible?
If it is possible how to write the compress statement?

Exp_ts timestamp(6) NOT NULL Compress ??????

Thanks
1 REPLY
Junior Contributor

Re: compress Timestamp(6)

You can't compress a Timestamp value.

Only NULLs might be compressed for Time/Timestamp/Interval...

Dieter