16:48:20 idle>select to_char(sysdate,'Day') from dual;
TO_CHAR(SYSDA
-------------
Thursday
16:58:35 sys@ORCL>select to_char(sysdate,'DAY') from dual;
TO_CHAR(SYSDA
-------------
THURSDAY
16:59:56 sys@ORCL>select to_char(sysdate,'day') from dual;
TO_CHAR(SYSDA
-------------
thursday
16:51:32 sys@ORCL>select to_char(sysdate,'D') from dual;
T
-
5
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16566331/viewspace-677376/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
修改sqlplus提示符
请登录后发表评论
登录
全部评论
