Working with date in JDBC

[kundana sharma]

I have a column name from_date as a timestamp in my Oracle Database.
Sample data:

 from_Date                      Account_NO           balance
13-Dec-12 8:34:54 PM              190               44534.90  
27-Dec-12 7:41:54 PM              190               12574.80
21-Dec-12 6:561:54 PM            190               4434.90
17-Dec-12 7:41:54 PM              190               4574.80

 

The Question is How can I extract only the day part from the database using JDBC in java code.I mean I just need the '13' part in 13-Dec-12 7:41:54 PM ,'27' part in 27-Dec-12 7:41:54 PM.
I want the data to be in an array in increasing order.
please help I am not well versed in java.

[Swastik Dey]

You can probably use oracle's extract function here.

select extract(day from from_date) from tablename

[Pyla Rao]

you can use java StringTokenizer.

[Swastik Dey]

If you can get the formatted value from the query itself, then what's the need to use StringTokenizer, please correct me if I am wrong.

[kundana sharma]

I am stuck here.

String day="select extract(day from from_date) from month_txn where account_no="+accno;
            Statement st2;
            ResultSet rs2;
            st2=conn.createStatement();
            rs2=st2.executeQuery(day);

I am not able to make out What result set contains.Is it an array of ints?
please help Dey
My task:I want to calculate interest for an account_no at the end of the month.
Sample database:

From_date                      Account_no                  balance
13-Dec-12 8:34:54 PM              190               44534.90
14-Dec-12 8:34:54 PM              191               44534.90
15-Dec-12 8:34:54 PM              193               44534.90
15-Dec-12 8:34:54 PM              194               44534.90
16-Dec-12 8:34:54 PM              191               44534.90
19-Dec-12 8:34:54 PM              191               44534.90
17-Dec-12 8:34:54 PM              196               44534.90
18-Dec-12 8:34:54 PM              192               44534.90

Code for calculating interest:

        try {
            
            
            sqlAccNo="select balance from month_txn where account_no="+accno;
            
            day="select extract(day from from_date) from month_txn where account_no="+accno;
            Statement st2;
            ResultSet rs2;
            st2=conn.createStatement();
            rs2=st2.executeQuery(day);
            st=conn.createStatement();
            rs=st.executeQuery(sqlAccNo);
            while(rs2.next()){
                int rowCount1=rs2.getRow();
                System.out.println(rowCount1);
                
                }
            while (rs.next()) { 
                double principle=rs.getDouble(1);
                
                System.out.println(principle);
                  interest =interest+(principle*0.02688*0.08); 
                                                //Interest cal: (balance on day[0])*(day[1]-day[0])*roi(8%pa) 
                                               //.I need a day array for the shown calculation.
                System.out.println("Interest is "+interest);
                  int rowCount = rs.getRow();
               System.out.println(rowCount);
                

       
        }

I am not able to make out how to extract timestamp into result set and then use it.
please help.

[Swastik Dey]

It didn't allow me to post the code in code tags.
try {
sqlAccNo="select count(*) from month_txn where account_no="+accno;
day="select extract(day from from_date) day,balance from month_txn where account_no="+accno +" order by day";
Statement st2;
ResultSet rs2;
st2=conn.createStatement();
rs2=st2.executeQuery(day);
st=conn.createStatement();
rs=st.executeQuery(sqlAccNo);
double arr[][]=null;
if(rs2.next()){
int rowCount1=rs2.getInt(1);
arr=new double[rowCount1][2];

}
int ctr=0;
while (rs.next()) {
String day=rs.getString(1);
double principle=rs.getDouble(2);
arr[ctr][0]=Double.parseDouble[day];
arr[ctr][1]=principle;
ctr++;

}
//arr should have now day and balance for that day

[kundana sharma]

can you please explain what is happening from declaration of the 2d array through till end.

[Swastik Dey]

Where do you find the 2nd array. There is only one array with 2 dimensions. 1st element contains the day and 2nd element contains the balance.

[Wendy Gibbons]

Swastik Dey wrote:Where do you find the 2nd array. There is only one array with 2 dimensions. 1st element contains the day and 2nd element contains the balance.

he didn't say second he said 2 dimensional (2d)