Example Display Formats - Teradata Vantage - Analytics Database

SQL Data Types and Literals

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
uds1628112204571.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
exs1472253032394
lifecycle
latest
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