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

posted @ 2017-04-04 17:00  yuerspring  阅读(118)  评论(0)  编辑  收藏  举报