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