ORA-01810: format code appears twice ORA-02063: preceding line from PULSARL
793919May 29 2011 — edited May 29 2011Hi ,
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 ??