Kanji Time Markers

Teradata Vantage™ Data Types and Literals

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

Kanji characters are valid in the FORMAT clause as markers for time information in TIME and TIMESTAMP data types. The following table lists the appropriate markers, their Kanji characters, and their description.

Marker Kanji Character Description
JI U+6642 (時) Hours
FUN U+5206 (分) Minutes
BYOU U+79D2 (秒) Seconds

For example, applying (FORMAT ‘99時99分99秒') to 010203 yields 01時02分03秒.

You can use Kanji characters with fractional seconds in TIME and TIMESTAMP formatting. For example:

CREATE TABLE t3
 (tstart TIME(2) FORMAT 'HH時MI分SS.S(2)秒'
 ,tend TIME FORMAT 'HH時MI分SSDS(F秒');

Time data must include the same Kanji time markers that appear in the FORMAT phrase. For example, the following CREATE TABLE statement uses the FORMAT phrase to define the display format for a TIMESTAMP column.

CREATE TABLE t2
 (tstart TIMESTAMP FORMAT 'YY年MM月DD日HH時MI分SS秒');

The following INSERT statement is valid, because the character string data includes the Kanji time markers specified in the FORMAT phrase.

INSERT t2 ('92年03月10日18時06分23秒');