Difference between two timestamp fields

[JayaSiji Gopal]

I have two fields DECISION_DATE and EVENT_DATE
Both are of type Timestamp in the database(DB2 v8)

i want to check if the diff between the two dates is 1.

I tried days(DECISION_DATE) - days(EVENT_DATE) = 1 .

I get the exception: days() is not a valid function.

What would be the best way?

[Qussay Najjar]

Hi JayaSiji,
Honestly I don't know the solution for this using Java methods,
I've faced this problem before, but as I'm using Oracle DB I used a query as the next:

public boolean isDifferentOne(Connection connection, Timestamp decisionDate , Timestamp eventDate){
        if(decisionDate==null || eventDate==null)
            return false;
        Statement statement = null;
        ResultSet rs = null;
        String query = "SELECT To_Date('"+eventDate.toString()+"','YYYY-MM-DD HH24:MI:SS')-To_Date('"+decisionDate.toString()+"','YYYY-MM-DD HH24:MI:SS') FROM DUAL";
        int subtractResult=0;
        try{
            statement = connection.createStatement();
            rs = statement.executeQuery(query);
            if(rs.next())
                try{subtractResult = rs.getInt(1);}catch(NullPointerException npe){subtractResult=0;}
               rs.close();
               statement.close();
               if(subtractResult==1) return true;
        }catch(SQLException e){
            return false;
        }
        return false;
}

This is how I solved my problem that day, hope it helps or gives a clue..