The following SQL statement creates a TIME column in t_time that is compressed when stored and uncompressed when retrieved from storage:
CREATE table t_time(i int, j time(6) compress using td_sysfnlib.ts_compress decompress using td_sysfnlib.ts_decompress);
If you insert the following TIME values into column j:
INSERT into t_time(1, TIME'06:26:44.820000'); INSERT into t_time(2, TIME'10:26:44.820000');
The following SQL statement:
SELECT j from t_time;
returns the 2 uncompressed TIME values that were compressed when the values were inserted in the table t_time.