Re: JDBC Timestamp comparison

From: Joe Weinstein <joeNOSPAM_at_bea.com>
Date: Wed, 21 Sep 2005 11:15:13 -0700
Message-ID: <4331A331.7000804@bea.com>

You didn't say what driver you're using... This code seems to work for me:

       c = d.connect("jdbc:oracle:thin:@joe:1521:S9205", props);
       System.out.println(c.getMetaData().getDriverVersion() );

       Statement s = c.createStatement();
       try{s.executeUpdate("drop table joe");} catch (Exception ignore){}

       s.executeUpdate("create table joe ( ID TIMESTAMP )");
       s.executeUpdate("insert into joe values(SYSDATE)");

       ResultSet r = s.executeQuery("select * from joe where ID >= CURRENT_TIMESTAMP - 12/24");
       while (r.next()) System.out.println("we got " + r.getString(1) );

I get:

10.1.0.4.0
we got 2005-9-22.3.10. 17. 0

If I change it to r.getTimestamp(1).getTime() I get a typical long, like 1127387595000

Joe Weinstein at BEA Systems

suresh wrote:

> public void testQuery() {
> Connection con = null;
> Statement stmt = null;
> ResultSet resultSet = null;
> try {
> con = getConnection();
> stmt = con.createStatement();
> String sql = "select * from message_log where log_timestamp
>

>>= CURRENT_TIMESTAMP

>
> -12/24";
>
> resultSet = stmt.executeQuery(sql);
> if(resultSet.next()) {
> System.out.println("Trade No XX: " +
> resultSet.getInt(1));
> System.out.println("Message Timestamp: " +
> resultSet.getTimestamp(2).getTime());
> }
> } catch (Exception e) {
> e.printStackTrace();
> System.out.println("Error running test " + e.getMessage());
> } finally {
> closeConnection(resultSet, stmt, con);
> }
> }
>
Received on Wed Sep 21 2005 - 13:15:13 CDT