oracle获取当前月的第一个星期五
select TO_CHAR(sysdate,'MM') || '月' || case when to_char(trunc(sysdate, 'month'), 'D')<=6 then 7-to_char(trunc(sysdate,'month'),'D') else 7 end || '号是当月的第一个星期五' from dual;
if you want to go fast,go alone,if you want to go far,go together