query involving time stamp

Hi Experts,
Can some one please highlight the mistake and its fix in the query below? Thanks.

select id,measure, last_day(to_date(frcstprdenddt,'rrmm')) as frcstprdenddt, periodicity, estimator,
to_timestamp( to_char(announcestopdt,'mm/dd/yyyy') || ' ' ||announcestoptm , 'HH24:MI:SS.FF') as announcestopdt
from raw_ibesstpepsatus
and frcstprdenddt<>'0'
order by id, measure, frcstprdenddt, periodicity, estimator, announcestopdt, announcestoptm;

I get ORA-01830: date format picture ends before converting entire input string

Quote:

---

Originally Posted by Abhijat

Hi Experts,
Can some one please highlight the mistake and its fix in the query below?

---

Here:

Code:

---

to_timestamp(to_char(announcestopdt,'mm/dd/yyyy')||' '||announcestoptm, 'MM/DD/YYYY HH24:MI:SS.FF')
-- Here -----------------------------------------------------------------^^^^^^^^^^^

---

:rolleyes:

thanks!