Teradata Forums / Data Warehousing / Teradata / compress Timestamp(6) / Latest PostsInstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 21:25:47 GMT20RE: compress Timestamp(6)http://www.teradata.com/teradataforum/Topic3341-1-1.aspxYou can't compress a Timestamp value.<br><br>Only NULLs might be compressed for Time/Timestamp/Interval...<br><br>DieterWed, 11 Jan 2006 13:53:20 GMTdnoethcompress Timestamp(6)http://www.teradata.com/teradataforum/Topic3341-1-1.aspxIs there a way to compress timestamp(6) field.<br>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?<br>If it is possible how to write the compress statement?<br><br>Exp_ts timestamp(6) NOT NULL Compress ??????<br><br>ThanksWed, 11 Jan 2006 13:44:23 GMTferoz_shaik