Example Display Formats - Advanced SQL Engine - Teradata Database

SQL Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
zsn1556242031050.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1143
lifecycle
previous
Product Category
Teradata Vantageā„¢

Examples of character string, numeric, and date formats appear in the following table.

FORMAT Data Display Form
X(6) 'HELLO'
'HELLO '
XXXXXX 'HELLO'
'HELLO '
X 'HELLO'
'H'
$$9.99 .079
' $0.08'
$$9.99 1095
******
ZZ,ZZ9.99 1095
' 1,095.00'
9.99E99 1095
'1.09E03'
999V99 123.456
'12346'
$(5).9(2) 1
'$1.00'
G--(8)D9(2) -12345678.90
'-12 345 678,90'

where the SDF defines the group separator as ' ' (blank) and the radix separator as ','.

Z(I)D9(F) 000000.42
',42'

where the SDF defines the radix separator as ','.

YY.DDD 85.224
'85.224'
MMMBDD,BYY Sep 12, 85
'Sep 12, 85'
YYYY-MM-DD 1996-02-14
'1996-02-14'
YYYYBMMMBDD 1985 Sep 12
'1985 Sep 12'
KatakanaEBCDIC with default format

Note that KatakanaEBCDIC uppercases single-byte data.

mN<ABC>b
MN<ABC>B