Информационное агентство Муниципальная Россия, инвестиционный форум, местное самоуправление, муниципальные образования, городские округа и муниципальные районы, инвестиционные паспорта, стратегии развития

ORA-01840: вводимое значение недостаточно длинное для формата даты
select ns, cun, vr, date_r, ris, podp, nazv, sodr,url,url_nam, time_r from (select rownum as ns, cun, vr, date_r, ris, podp, nazv, sodr,url,url_nam, time_r from (select cun, TO_TIMESTAMP(date_r || ' ' || time_r,'dd/mm/yyyy hh24:mi:ss') as vr, date_r, ris, podp, nazv, sodr,url,url_nam, time_r from (select id_cuc as id,utl_raw.cast_to_varchar2(cuc_value) as cat,id_cun as cun,id_lang as lang,id_cuc_lnk as lnk from rusitc.CUC where (id_cun in (select id_cun as n_id from rusitc.cun where id_us=1248 and cun_transltd=1) and id_sgn=1705)) a left join (select utl_raw.cast_to_varchar2(cuc_value) as date_r,id_cuc_lnk from rusitc.CUC where id_sgn=329) b on lnk=b.id_cuc_lnk left join (select id_cuc_lnk, utl_raw.cast_to_varchar2(cuc_value) as time_r from rusitc.CUC where id_sgn=1554) t on t.id_cuc_lnk=lnk left join (select utl_raw.cast_to_varchar2(cuc_value) as ris,ID_cuc_lnk as lnk from rusitc.CUC where id_sgn=1482) d on a.lnk=d.lnk left join (select utl_raw.cast_to_varchar2(cuc_value) as podp, id_cun from rusitc.CUC where id_sgn=682) e on a.cun=e.id_cun left join (select utl_raw.cast_to_varchar2(cuc_value) as nazv,id_cun from rusitc.CUC where id_sgn=332) f on a.cun=f.id_cun left join (select utl_raw.cast_to_varchar2(cuc_value) as sodr,id_cun as cun2 from rusitc.CUC where id_sgn=3258) g on a.cun=g.cun2 left join (select utl_raw.cast_to_varchar2(cuc_value) as url,ID_cuc_lnk as lnk from rusitc.CUC where id_sgn=1604) h on a.lnk=h.lnk left join (select utl_raw.cast_to_varchar2(cuc_value) as url_nam,id_cun as cun2 from rusitc.CUC where id_sgn=1603) k on a.cun=k.cun2 order by vr desc)) where ns>? and ns<=?