•SELECT EXTRACT(YEAR FROM SYSDATE) FROM DUAL; return Current Year
•SELECT EXTRACT(MONTH FROM SYSDATE) FROM DUAL; return Current Month
•SELECT EXTRACT(DAY FROM SYSDATE) FROM DUAL; return Current Day
•SELECT EXTRACT(HOUR FROM SYSDATE) FROM DUAL;Error
Correct:SELECT EXTRACT(HOUR FROM TIMESTAMP '2005-10-10 10:10:10') FROM DUAL;
•SELECT EXTRACT(MINUTE FROM SYSDATE) FROM DUAL;Error
Correct:SELECT EXTRACT(MINUTE FROM TIMESTAMP '2005-10-10 10:10:10') FROM DUAL;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10356975/viewspace-680332/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
没有了~
下一篇：
java实现99乘法表
请登录后发表评论
登录
全部评论
