一个简单，组合强大de SQL

select dayofweek(current date) as dofweek ,day(current date) as current_days,current date as current_date from sysibm.sysdummy1 DOFWEEK current_days CURRENT_DATE ------- ---- ------------ 3 4 2017-04-04 ---today is Tuesday