Hi all,
When I try to display records between two dates 01/01/2010 and 03/01/2010, It is displaying data for 01/01/2010,01/02/2009,01/02/20 10,01/03/2009,
01/03/2010.
It is additionally displaying 2009 data which I dont want to display.Please help to solve this problem.
I am using following query
SELECT
a.DETECTORID,
aram1,aram2,aram3,
b.TOTALVOLUME,
to_char(a.UPDATETIME,'MM/DD/YY YY') as UPDATETIME
from traffic_data_arc a left outer join volume_data_arc b on a.traffic_id = b.traffic_data_id and a.server = b.server
where POLLINTERVAL= 3
and DETECTORID like concat(concat('%',aram1),'%' )
and to_char(a.UPDATETIME,'MM/DD/YY YY') between to_charparam2,'MM/DD/YYYY') and to_charparam3,'MM/DD/YYYY')
Please help
Rgds,
natbal
When I try to display records between two dates 01/01/2010 and 03/01/2010, It is displaying data for 01/01/2010,01/02/2009,01/02/20 10,01/03/2009,
01/03/2010.
It is additionally displaying 2009 data which I dont want to display.Please help to solve this problem.
I am using following query
SELECT
a.DETECTORID,
aram1,aram2,aram3,
b.TOTALVOLUME,
to_char(a.UPDATETIME,'MM/DD/YY YY') as UPDATETIME
from traffic_data_arc a left outer join volume_data_arc b on a.traffic_id = b.traffic_data_id and a.server = b.server
where POLLINTERVAL= 3
and DETECTORID like concat(concat('%',aram1),'%' )
and to_char(a.UPDATETIME,'MM/DD/YY YY') between to_charparam2,'MM/DD/YYYY') and to_charparam3,'MM/DD/YYYY')
Please help
Rgds,
natbal