oracle数据库 时间，week轴查看数据语句

单位需要导出一份按照时间轴排列的数据，并列出是周几，代码如下，仅供参考：  
sql = """SELECT t2.NAME, t2.AREA, t2.PRICE, t2.PER, t2.CHG, t2.HIGHEST, t2.LOWEST, t2.N_LEVEL, t2.DATA_DATE, t2.week ,to_char(t1.days,'yyyy-mm-dd') day_data
  from (select  to_date('2015-01-01', 'yyyy-mm-dd')+level -1  as days from dual b
  connect by to_date('2015-01-01', 'yyyy-mm-dd') + level -1 <= to_date('2018-08-22', 'yyyy-mm-dd')) t1
  left join (
  select  '{PRODUCT_NAME}' name, '{AREA}' area, t.price, '元/吨' per, t.CHG, t.HIGHEST, t.LOWEST, t.N_LEVEL, t.DATA_DATE,
      to_char(to_date(t.data_date,'yyyy-mm-dd'),'day','NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE''') as
  week from {TABLE_NAME} t where t.code='{CODE}'
) t2 on to_char(t1.days,'yyyy-MM-dd')=t2.data_date order by t1.days""".format(PRODUCT_NAME=product_name,AREA=area,TABLE_NAME=table_name,CODE=code)