Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display records between two dates

Status
Not open for further replies.

natbal

IS-IT--Management
Jan 18, 2010
1
US
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,
:param1,:param2,:param3,
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('%',:param1),'%' )
and to_char(a.UPDATETIME,'MM/DD/YY YY') between to_char:)param2,'MM/DD/YYYY') and to_char:)param3,'MM/DD/YYYY')

Please help

Rgds,
natbal
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top