16.20 - Example: Creating a Compressed TIME Column - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Administration
Programming Reference
Publication ID
B035-1210-162K
Language
English (United States)

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.