YashanDB EXTRACT 函数

-- 创建times表，包含DATE、TIMESTAMP、TIME、INTERVAL DAY TO SECOND、INTERVAL YEAR TO MONTH类型的列字段CREATE TABLE times (timea DATE DEFAULT SYSDATE,timeb TIMESTAMP DEFAULT SYSDATE,timec TIME DEFAULT SYSDATE,timed INTERVAL DAY TO SECOND,timee INTERVAL YEAR TO MONTH);INSERT INTO times VALUES (DEFAULT,DEFAULT,DEFAULT,INTERVAL '5' DAY,INTERVAL '2' YEAR);COMMIT; SELECT timea,timeb,timec,timed,timee FROM times;TIMEA                 TIMEB                        TIMEC             TIMED                TIMEE --------------------- ---------------------------- ----------------- -------------------- ------2022-01-17 20:47:19   2022-01-17 20:47:19.000000   20:47:19.000000   +05 00:00:00.000000  +02-00 SELECT EXTRACT(YEAR FROM timea) Year,EXTRACT(SECOND FROM timeb) Second,EXTRACT(HOUR FROM timec) Hour,EXTRACT(DAY FROM timed) Day,EXTRACT(MONTH FROM timee) MonthFROM times;        YEAR      SECOND         HOUR          DAY        MONTH------------ ----------- ------------ ------------ ------------        2022          19           20            5            0