Teradata - 日期函数

SELECT DATE;

SELECT EXTRACT(YEAR FROM DATE);

SELECT EXTRACT(MONTH FROM DATE+30);

SELECT EXTRACT(DAY FROM DATE+2);

SELECT TIME; SELECT EXTRACT(HOUR FROM TIME);

SELECT EXTRACT(MINUTE FROM TIME);

SELECT EXTRACT(SECOND FROM TIME);

SELECT ADD_MONTHS(DATE,2);

SELECT ADD_MONTHS(DATE,12*8);

SELECT ADD_MONTHS('2002-03-19',12);