一、获取当前时间转换成星期几
方法一:
select substr(to_char(sysdate,'day','NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE'''),-1) from dual;
方法二:
select
DECODE(dw,
7,
'星期天',
1,
'星期一',
2,
'星期二',
3,
'星期三',
4,
'星期四',
5,
'星期五',
6,
'星期六') WEEK_DAY
FROM (select to_char(sysdate-1,'d')dw from dual)
二、根据指定的日期转换成星期几
方法一:
SELECT DECODE(dw,
0,
'星期天',
1,
'星期一',
2,
'星期二',
3,
'星期三',
4,
'星期四',
5,
'星期五',
6,
'星期六') WEEK_DAY
FROM (SELECT 7 - TO_NUMBER(NEXT_DAY(TO_DATE('2017-09-21', 'yyyy-mm-dd'), 1) -TO_DATE('2017-09-21', 'yyyy-mm-dd')) dw
FROM dual);
方法二:
select substr(to_char(to_date('2015-01-20','yyyy-mm-dd'),'day','NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE'''),-1) from dual;