arshad Posted April 22, 2015 Report Posted April 22, 2015 nen 2 ante nu 8 eskunav..error rammante raadha?
nenu_devudni Posted April 22, 2015 Author Report Posted April 22, 2015 nen 2 ante nu 8 eskunav..error rammante raadha? ante hours min sec kuda kavali ani .. sonta telivi use chesa ... bye1 and ucbsvco_date_created >= to_date(substr(uwtsmdm_ext_read_time,5,3)||'-'||substr(uwtsmdm_ext_read_time,9,2)||'-'||substr(uwtsmdm_ext_read_time,25,4)||'-'||substr(uwtsmdm_ext_read_time,12,2),'MM-DD-YYYY HH24:MM:SS') - 1 and to_date(substr(uwtsmdm_ext_read_time,5,3)||'-'||substr(uwtsmdm_ext_read_time,9,2)||'-'||substr(uwtsmdm_ext_read_time,25,4)||'-'||substr(uwtsmdm_ext_read_time,12,2),'MM-DD-YYYY HH24:MM:SS') = trunc(sysdate) still same error bhaya .. :#<
arshad Posted April 22, 2015 Report Posted April 22, 2015 ante hours min sec kuda kavali ani .. sonta telivi use chesa ... bye1 and ucbsvco_date_created >= to_date(substr(uwtsmdm_ext_read_time,5,3)||'-'||substr(uwtsmdm_ext_read_time,9,2)||'-'||substr(uwtsmdm_ext_read_time,25,4)||'-'||substr(uwtsmdm_ext_read_time,12,2),'MM-DD-YYYY HH24:MM:SS') - 1 and to_date(substr(uwtsmdm_ext_read_time,5,3)||'-'||substr(uwtsmdm_ext_read_time,9,2)||'-'||substr(uwtsmdm_ext_read_time,25,4)||'-'||substr(uwtsmdm_ext_read_time,12,2),'MM-DD-YYYY HH24:MM:SS') = trunc(sysdate) still same error bhaya .. :#<
prassanna Posted April 22, 2015 Report Posted April 22, 2015 to_date(substr(uwtsmdm_ext_read_time,5,3)||'-'||substr(uwtsmdm_ext_read_time,9,2)||'-'||substr(uwtsmdm_ext_read_time,25,4)||'-'||substr(uwtsmdm_ext_read_time,12,8),'MM-DD-YYYY HH24:MM:SS') edi chesa bhayya .. error ostundi , format code appears twice ani try like this.. SELECT TO_DATE( SUBSTR('Tue Aug 26 14:14:44 CDT 2014',5,3)||'-'|| SUBSTR('Tue Aug 26 14:14:44 CDT 2014',9,2)||'-'|| SUBSTR('Tue Aug 26 14:14:44 CDT 2014',25,4)||' '|| SUBSTR('Tue Aug 26 14:14:44 CDT 2014',12,2)||':'|| SUBSTR('Tue Aug 26 14:14:44 CDT 2014',15,2)||':'|| SUBSTR('Tue Aug 26 14:14:44 CDT 2014',18,2),'MM-DD-YYYY HH24:MI:SS') as dat FROM DUAL;
prassanna Posted April 22, 2015 Report Posted April 22, 2015 SELECT TO_DATE( SUBSTR(uwtsmdm_ext_read_time,5,3)||'-'|| SUBSTR(uwtsmdm_ext_read_time,9,2)||'-'|| SUBSTR(uwtsmdm_ext_read_time,25,4)||' '|| SUBSTR(uwtsmdm_ext_read_time,12,2)||':'|| SUBSTR(UWTSMDM_EXT_READ_TIME,15,2)||':'|| SUBSTR(uwtsmdm_ext_read_time,18,2),'MM-DD-YYYY HH24:MI:SS') as nendevudni FROM uwtsmdm_el_ext;
prassanna Posted April 22, 2015 Report Posted April 22, 2015 ante hours min sec kuda kavali ani .. sonta telivi use chesa ... bye1 and ucbsvco_date_created >= to_date(substr(uwtsmdm_ext_read_time,5,3)||'-'||substr(uwtsmdm_ext_read_time,9,2)||'-'||substr(uwtsmdm_ext_read_time,25,4)||'-'||substr(uwtsmdm_ext_read_time,12,2),'MM-DD-YYYY HH24:MM:SS') - 1 and to_date(substr(uwtsmdm_ext_read_time,5,3)||'-'||substr(uwtsmdm_ext_read_time,9,2)||'-'||substr(uwtsmdm_ext_read_time,25,4)||'-'||substr(uwtsmdm_ext_read_time,12,2),'MM-DD-YYYY HH24:MM:SS') = trunc(sysdate) still same error bhaya .. :#< and ucbsvco_date_created >= TO_DATE( SUBSTR(uwtsmdm_ext_read_time,5,3)||'-'|| SUBSTR(uwtsmdm_ext_read_time,9,2)||'-'|| SUBSTR(uwtsmdm_ext_read_time,25,4)||' '|| SUBSTR(uwtsmdm_ext_read_time,12,2)||':'|| SUBSTR(UWTSMDM_EXT_READ_TIME,15,2)||':'|| SUBSTR(uwtsmdm_ext_read_time,18,2),'MM-DD-YYYY HH24:MI:SS') - 1 and TO_DATE( SUBSTR(uwtsmdm_ext_read_time,5,3)||'-'|| SUBSTR(uwtsmdm_ext_read_time,9,2)||'-'|| SUBSTR(uwtsmdm_ext_read_time,25,4)||' '|| SUBSTR(uwtsmdm_ext_read_time,12,2)||':'|| SUBSTR(UWTSMDM_EXT_READ_TIME,15,2)||':'|| SUBSTR(uwtsmdm_ext_read_time,18,2),'MM-DD-YYYY HH24:MI:SS') = trunc(sysdate)
nenu_devudni Posted April 22, 2015 Author Report Posted April 22, 2015 try like this.. SELECT TO_DATE( SUBSTR('Tue Aug 26 14:14:44 CDT 2014',5,3)||'-'|| SUBSTR('Tue Aug 26 14:14:44 CDT 2014',9,2)||'-'|| SUBSTR('Tue Aug 26 14:14:44 CDT 2014',25,4)||' '|| SUBSTR('Tue Aug 26 14:14:44 CDT 2014',12,2)||':'|| SUBSTR('Tue Aug 26 14:14:44 CDT 2014',15,2)||':'|| SUBSTR('Tue Aug 26 14:14:44 CDT 2014',18,2),'MM-DD-YYYY HH24:MI:SS') as dat FROM DUAL; thanks bhayya .. it worked (.L@
Yuvatha Posted April 22, 2015 Report Posted April 22, 2015 thanks bhayya .. it worked (.L@ direct ga velli pettu..he accepts
prassanna Posted April 22, 2015 Report Posted April 22, 2015 thanks bhayya .. it worked (.L@ no problem..
prassanna Posted April 22, 2015 Report Posted April 22, 2015 direct ga velli pettu..he accepts yes..m bi..
Yuvatha Posted April 22, 2015 Report Posted April 22, 2015 :3D_Smiles: :3D_Smiles: :3D_Smiles: yes..m bi..
nenu_devudni Posted April 22, 2015 Author Report Posted April 22, 2015 INSERT INTO UWTSMEE (uwtsmee_alert_time) SELECT TO_DATE(SUBSTR(uwtsmdm_ext_read_time,5,2)||'-'|| SUBSTR(uwtsmdm_ext_read_time,7,2)||'-'|| SUBSTR(uwtsmdm_ext_read_time,1,4)||' '|| SUBSTR(uwtsmdm_ext_read_time,10,2)||':'|| SUBSTR(uwtsmdm_ext_read_time,13,2)||':'|| SUBSTR(uwtsmdm_ext_read_time,16,2),'MM-DD-YYYY HH24:MI:SS') FROM UWTSMDM_EL_EXT bhayya na loader script lo .. manam fetch chesina date field lo . hours data insert avatledu .. jus date okate insert avtundi :3D_Smiles_38: ex # 02-JUL-2014
Recommended Posts