Sql Help

[nenu_devudni]

 

ee query lo .

[SUbba LIngam]

instead of -24 can you try -1 and see

[nenu_devudni]

instead of -24 can you try -1 and see

 

[nenu_devudni]

CITI#H@

[jackson]

Try trunc(UWTSMEE_ALERT_TIME) - 1

[prassanna]

Try trunc(UWTSMEE_ALERT_TIME) - 1

Agreed

[Yuvatha]

Agreed

ok

[nenu_devudni]

jfghj

[nenu_devudni]

LTT  CITI#H@

[Pichkaari]

pwd ..

[CheGuevara]

csv file lo date field vastundi .. dani table lo current date (uwtsmdm_ext_read_time) okate load cheyali migita dates anni ignore cheyali .. deniki query ela rayocho kasta chepandi

select *
from ucbsvco, ucrserv, uwtsmdm_el_ext
where ucbsvco_prem_code = ucrserv_prem_code
and ucbsvco_date_created >= trunc(TO_DATE(uwtsmdm_ext_read_time,'YYYYMMDD HH24:MI:SS')) - 1
and SUBSTR(uwtsmdm_ext_meter_model,6) = ucrserv_invn_code
and ucrserv_styp_code like '%ELC'
and uwtsmdm_ext_alert_msg = 'Tilt Warning'
and uwtsmdm_ext_alert_type = 'Tamper Alert'

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

Okasari aa filed lo date format cheppu with an example from file

[nenu_devudni]

Okasari aa filed lo date format cheppu with an example from file

Tue Aug 26 14:14:44 CDT 2014

[nenu_devudni]

pwd ..

bye1

[prassanna]

em ra ochindha..??

[nenu_devudni]

em ra ochindha..??

bye1  rale