YEARWEEK(date):取得日期的年和週SELECT YEARWEEK(SYSDATE()) SELECT YEARWEEK(‘2015-01-10') SELECT YEARWEEK(‘2015-01-10',1)登入後複製-> 201602 -> 201501 -> 201502登入後複製