Kanji Time Markers | Date Types and Literals | Teradata Vantage - 17.10 - Kanji Time Markers - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

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秒');