摘要： create or replace view v_timedimension asselect to_date(a.STARTTIME,'yyyy-mm-dd hh24:mi:ss') as starttime ,substr(a.starttime,1,4) as year,substr(a.starttime,1,7) as month, substr(a.starttime,1,10) as... 阅读全文