显示今天星期几

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博客 ” ，链接：http://blog.itpub.net/16566331/viewspace-677376/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16566331/viewspace-677376/