如何取得当天是星期几？

Question

13:45:16 SQL> select to_char(sysdate,'day') from dual;TO_CHA
------
星期五已用时间:  00: 00: 00.00
13:45:18 SQL>

Answer 1

TO_CHAR(SYSDATE,'W') 这个是取当月的第几个周吧

Answer 2

SQL> select to_char(sysdate,'day') from dual;TO_CHAR(SYSDATE,'DAY')
----------------------
星期五SQL> select to_char(sysdate,'w') from dual;TO_CHAR(SYSDATE,'W')
--------------------
5

Answer 3

13:49:18 SQL> select decode(to_char(sysdate,'d')-1,0,7,to_char(sysdate,'d')-1) from dual;DECODE(TO_CHAR(SYSDATE,'D')-1,0,7,TO_CHAR(SYSDATE,'D')-1)
---------------------------------------------------------
                                                        5已用时间:  00: 00: 00.16
13:49:39 SQL>