一个简单，组合强大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