单位需要导出一份按照时间轴排列的数据,并列出是周几,代码如下,仅供参考:
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)
oracle数据库 时间,week轴查看数据语句
最新推荐文章于 2024-01-12 00:30:00 发布