16.20.16.20 - 16.20 - Example Display Formats - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

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