compress Timestamp(6)

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

compress Timestamp(6)

Rate Topic

Display Mode

Topic Options

Author

Message

feroz_shaik

Posted 1/11/2006 1:44:23 PM

Supreme Being

Group: Forum Members
Last Login: Yesterday @ 12:54:51 PM
Posts: 116, Visits: 20

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

Feroz Shaik

Post #3341

dnoeth

Posted 1/11/2006 1:53:20 PM

Supreme Being

Group: Forum Members
Last Login: 10/3/2008 7:39:41 AM
Posts: 483, Visits: 213

You can't compress a Timestamp value.

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

Dieter

Post #3342

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 3:12am