Oracle函数

概述-- EXTRACT函数：返回具体的年、月、日、时、分、秒等具体时间。SELECT EXTRACT (YEAR FROM --SYSDATE SYSTIMESTAMP ) YEAR FROM DUAL; SELECT EXTRACT (MONTH FROM --SYSDATE SYSTIMESTAMP ) YE @H_301_7@-- EXTRACT函数：返回具体的年、月、日、时、分、秒等具体时间。SELECT EXTRACT (YEAR FROM --SYSDATE SYSTIMESTAMP ) YEAR FROM DUAL; SELECT EXTRACT (MONTH FROM --SYSDATE SYSTIMESTAMP ) YEAR FROM DUAL; SELECT EXTRACT (DAY FROM --SYSDATE SYSTIMESTAMP ) YEAR FROM DUAL; SELECT EXTRACT (HOUR FROM SYSTIMESTAMP) YEAR FROM DUAL;SELECT EXTRACT (MINUTE FROM SYSTIMESTAMP) YEAR FROM DUAL;SELECT EXTRACT (SECOND FROM SYSTIMESTAMP) YEAR FROM DUAL;SELECT EXTRACT (DAY FROM SYSTIMESTAMP) YEAR FROM DUAL;SELECT EXTRACT(YEAR FROM ORDERDATE) AS O--EG:SELECT EXTRACT(YEAR FROM SYSDATE) AS YEAR_,EXTRACT(MONTH FROM SYSDATE) AS MONTH_,EXTRACT(DAY FROM SYSDATE) AS DAY_ FROM DUAL 总结

以上是内存溢出为你收集整理的Oracle函数全部内容，希望文章能够帮你解决Oracle函数所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。