Neoview SQL Reference Manual (R2.5)

----------- --------- ------------------------- -------------------------
07D8040F 0E201E 07D8040F0E201E00000035 07D8040F0E201E00081ABB
• Display the internal values for an INTERVAL YEAR column, an INTERVAL YEAR(2) TO
MONTH column, and an INTERVAL DAY TO SECOND column:
CREATE TABLE IVT ( IV1 interval year, IV2 interval year(2) to month,
IV3 interval day to second) no partition;
INSERT INTO IVT values( interval '1' year, interval '3-2' year(2) to month,
interval '31:14:59:58' day to second);
SELECT CONVERTTOHEX(IV1), CONVERTTOHEX(IV2), CONVERTTOHEX(IV3) from IVT;
(EXPR) (EXPR) (EXPR)
------ -------- -----------------------
0001 0026 0000027C2F9CB780
CONVERTTOHEX Function 367