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

SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2023-04-27
dita:mapPath
qqu1556127655717.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1210
lifecycle
previous
Product Category
Teradata Vantage™

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.