-
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
-
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 -----------------------------------------------------------------^^^^^^^^^^^
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|