Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01810: format code appears twice ORA-02063: preceding line from PULSARL

793919May 29 2011 — edited May 29 2011
Hi ,

I am running this query

select distinct to_char(a.USAGEDATE, 'dd/mm/yyyy hh:mm'),round((a.avgifoutoctets * a.numberofrows / (a.avgdeltatime * a.numberofrows) * 8 / 1000 ), 2)as avginoctetrate from vware.vhourlyrtgusageextract a ,vware.rtginterface b where a.id = b.ID and a.id = 125555 and a.USAGEDATE >= TO_CHAR(TO_DATE('2011-05-22 11:40:47', 'yyyy-MM-dd HH:mm:ss')) and a.USAGEDATE < TO_CHAR(TO_DATE('2011-05-29 11:40:47', 'yyyy-MM-dd HH:mm:ss')) and a.IFDESCRIPTION = 'Serial1/0' order by 1

I am getting this exception

ORA-01810: format code appears twice ORA-02063: preceding line from PULSARL

Could anybody please tell me what is the issue ??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2011
Added on May 29 2011
1 comment
25,188 views