1、当前时间的星期 select to_char(sysdate,'day') from dual ; 2、指定字段的星期 select decode (substr(to_char(t.字段,'d','NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE'''),-1),'1','星期日','2','星期一','3','星期二','4','星期三','5','星期四','6','星期五','7','星期六') as 星期 from 表名 t where t.字段 is not null ;