Oracle

Trying to pull and display records from today back 30 days....

Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Aug 2007

Posts: 66

Reputation: mimsc is an unknown quantity at this point

Solved Threads: 0

mimsc

Offline

Junior Poster in Training

Trying to pull and display records from today back 30 days....

Aug 15th, 2007

Here's my code...basically, I hard coded yesterday just to make sure it works...Im trying to get it to display results everyday

 Help with Code Tags 
 java Syntax (Toggle Plain Text) 
 String sqlStmt = "SELECT distinct count (lc.con_id) as TotalLeads FROM LEADS L inner join leads_contactinfo lc on l.fk_conid = lc.con_id" +
                        " WHERE l.FK_CONID = lc.CON_ID AND lc.FK_AGENTID = ? AND CON_INITDATE > to_date('2007/07/13', 'yyyy/mm/dd') AND CON_INITDATE < to_date('2007/08/14', 'yyyy/mm/dd')";
 String sqlStmt = "SELECT distinct count (lc.con_id) as TotalLeads FROM LEADS L inner join leads_contactinfo lc on l.fk_conid = lc.con_id" +
                        " WHERE l.FK_CONID = lc.CON_ID AND lc.FK_AGENTID = ? AND CON_INITDATE > to_date('2007/07/13', 'yyyy/mm/dd') AND CON_INITDATE < to_date('2007/08/14', 'yyyy/mm/dd')";

any suggestions would be greatly appreciated

•

Join Date: Feb 2007

Posts: 2,131

Reputation: debasisdas will become famous soon enough

Solved Threads: 131

debasisdas debasisdas is offline

Offline

Postaholic

Re: Trying to pull and display records from today back 30 days....

Aug 15th, 2007

instead of hardcoding the dates use sysdate and sysdate-30 for the desired output.

Share your Knowledge.

•

Join Date: Aug 2007

Posts: 66

Reputation: mimsc is an unknown quantity at this point

Solved Threads: 0

mimsc

Offline

Junior Poster in Training

Re: Trying to pull and display records from today back 30 days....

Aug 15th, 2007

thanx...let me try that

•

Join Date: Aug 2007

Posts: 66

Reputation: mimsc is an unknown quantity at this point

Solved Threads: 0

mimsc

Offline

Junior Poster in Training

Re: Trying to pull and display records from today back 30 days....

Aug 15th, 2007

ok...I tried that...im not too savvy with sql....should it look like this?:

String sqlStmt = "SELECT distinct count (lc.con_id) as TotalLeads FROM LEADS L inner join leads_contactinfo lc on l.fk_conid = lc.con_id" +
" WHERE l.FK_CONID = lc.CON_ID AND lc.FK_AGENTID = ? AND CON_INITDATE > to_date('sysdate-30', 'yyyy/mm/dd') AND CON_INITDATE < to_date('sysdate', 'yyyy/mm/dd')";