SELECT EXTRACT(MONTH FROM CURRENT_DATE); EXTRACT(MONTH FROM Date) --- 1 SELECT EXTRACT(DAY FROM CURRENT_DATE); EXTRACT(DAY FROM Date) --- 1 SELECT EXTRACT(HOUR FROM CURRENT_TIMESTAMP); EXTRACT(HOUR FROM Current TimeStamp(6)) --- 4 SELECT EXTRACT(MINUTE FROM CURRENT_TIMESTAMP); EXTRACT...
SELECTDATE;SELECTEXTRACT(YEARFROMDATE);SELECTEXTRACT(MONTHFROMDATE+30);SELECTEXTRACT(DAYFROMDATE+2);SELECTTIME;SELECTEXTRACT(HOURFROMTIME);SELECTEXTRACT(MINUTEFROMTIME);SELECTEXTRACT(SECONDFROMTIME);SELECTADD_MONTHS(DATE,2);SELECTADD_MONTHS(DATE,12*8);SELECTADD_MONTHS('2002-03-19',12); 19、在LI...
date=970331 于日期有关的数据函数 1.EXTRACT ANSI标准中EXTRACT函数允许选取日期和时间中任意段或任意间隔的值,Teradata中EXTRACT函数支持日期数据中选取年.月.日.从时间数据中选取小时.分钟和秒 SELECT DATE; 96/11/07 SELECT EXTRACT(YEAR FROM DATE); 1996 SELECT EXTRACT(MONTH FROM DATE+30); 12 SLEECT EX...
SELECT EXTRACT(MONTH FROM DATE+30); 12 SLEECT EXTRACT(DAY FROM DATE+2); 09 SELECT TIME; 14:52:32 SELECT EXTRACT(HOUR FROM TIME); 14 SELECT EXTRACT(SECOND FROM TIME+30); INVALID TIME 2.ADD_MONTHS 利用CAST作数据转换 ANSI标准中利用CAST函数将一种数据类型转换成另一种数据类型 select cast(s...
Select parent from dbc.children where child=’APPL1’; 注释:检查用户APPL1的所有父辈。 Select child from dbc.children where parent=’USERADMIN’; 注释:检查用户USERADMIN的所有后代。 7、Grant select on usera to userb with grant option;
EXTRACT --- select extract( year/month/day from date+30) ADD_MONTHS ---select add_months(date, -3) --select add_months(cast(flight_dt as date format ‘YYYYMMDD’) ,9) 1. 2. 3. 4. 5. 19. CAST 数据转换 以大写显示结果 select...
select * from sys_calendar.calendar where calendar_date = date-7 ⽇期存储 ⽇期使⽤以下公式在内部存储为整数。((YEAR - 1900) * 10000) + (MONTH * 100) + DAY 您可以使⽤以下查询来检查⽇期的存储⽅式。SELECT CAST(CURRENT_DATE AS INTEGER);由于⽇期存储为整数,您可以对...
SELECT EXTRACT (YEAR FROM DATE); 1996 SELECT EXTRACT (MONTH FROM DATE + 30); 12 SELECT EXTRACT (DAY FROM DATE + 2); 09 2. ADD_MONTHS ADD_MONTHS表示从某日期增加或减少指定月份的日期。它考虑了大小月问题,所以计算日期是准确的。 SELECT ADD_MONTHS (DATE, 2); 1996-10-07 ...
Select parent from dbc.children where child=’APPL1’; 注释:检查用户APPL1的所有父辈。 Select child from dbc.children where parent=’USERADMIN’; 注释:检查用户USERADMIN的所有后代。 7、Grant select on usera to userb with grant option;
SELECT EXTRACT (MONTH FROM CURRENT_DATE+90); SELECT EXTRACT (DAY FROM'1996-12-12'); 选项:YEAR| MONTH | DAY | HOUR | MINUTE | SECOND | TIMEZONE_HOUR | TIMEZONE_MINUTE 2. 差值计算 //日期差值(年/月/日)==只写day、month、year差值最大99天、99月、99年 ...