Sql Help

[prassanna]

bye1  rale 

already date lo unna dhanni to_date ga sesthe atlane aithadh raja..

[nenu_devudni]

already date lo unna dhanni to_date ga sesthe atlane aithadh raja..

adi date lo ledu .. string lo undi .. dani date lo convert chestuna .. danama ratle enta try chesina ... malli ade field ki current date ravali anta 

[prassanna]

uwtsmdm_ext_read_time ...idhi eh table lo undhi?

[nenu_devudni]

uwtsmdm_ext_read_time ...idhi eh table lo undhi?

uwtsmdm_el_ext  ...edi external table . .andulo string la store chestuna csv file nundi .. 

[prassanna]

select to_date(uwtsmdm_ext_read_time,'YYYY-MM-DD') from uwtsmdm_el_ext; 

 

idhi try chesthe emosthundhi?

[prassanna]

and 

 

select to_char(to_date(uwtsmdm_ext_read_time,'YYYY-MM-DD'),'YYYY-MM-DD') from uwtsmdm_el_ext;

 

idhi try chesthe emosthundhi?

[prassanna]

jus adhi try cheshi em error osthundho seppu..

[nenu_devudni]

rendu try chesa .. ee error ostundi  bye1

 

ORA-29913: error in executing ODCIEXTTABLEFETCH callout

ORA-01841: (full) year must be between -4713 and +9999, and not be 0

[prassanna]

 

rendu try chesa .. ee error ostundi  bye1

 

ORA-29913: error in executing ODCIEXTTABLEFETCH callout

ORA-01841: (full) year must be between -4713 and +9999, and not be 0

 

renditki same error aa..

[nenu_devudni]

renditki same error aa..

yes 

[prassanna]

devuda...

 

idhi try chey..

 

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),'MM-DD-YYYY') from dual;

 

idhe nek kavalsina solution..

[prassanna]

where ever i have the date...replace it with uwtsmdm_ext_read_time

[prassanna]

select to_date(substr(uwtsmdm_ext_read_time,5,3)||'-'||substr(uwtsmdm_ext_read_time,9,2)||'-'||substr(uwtsmdm_ext_read_time,25,4),'MM-DD-YYYY') from uwtsmdm_el_ext;

[prassanna]

try the last one..see if u get any error..

[prassanna]

so 1 day minus kavalante.. just add -1 to the query..that's it..