java.sql.timestamp versus date

Question

I am using Derby database with Java and Eclipse. I have a table which has a TIMESTAMP field and I use a model to populate a JTable from it. I am finding timestamp and data and java.sql and java.utils very confusing. The following line of code errors with cannot cast date to timestamp. mod is the model interfacing Derby table and JTable.

int rowcount = mod.getRowCount();
java.sql.Timestamp ts = (java.sql.Timestamp) mod.getValueAt(rowcount-1,1);

My objective is to get the date of the most recent record and subtract 30 days then run an sql query on the same database to find all the records more recent than that date. How do I recover the first timestamp, subtract the 30 days, then construct a query with the result of the subtraction as the condition in a WHERE clause. Sounds simple but I am having such difficulty that I feel I must be missing some fundamental principal. I thought conversion to long and back again might be the route but came up against the same cast problem.

Can't you use Derby built-in date functions to accomplish everything in one sql-request? — WeMakeSoftware
– WeMakeSoftware, Commented Jan 16, 2012 at 9:13

stacker · Accepted Answer · 2012-01-16 09:20:17Z

1

Timestamp is declared as

public class Timestamp extends java.util.Date { ... }

Therefore you can't cast date to timstamp, you could create a timestamp from a date.

Timstamp ts = new Timestamp( date.getTime() );

To subtract 30 days this sequence might be helpful:

Calendar cal = new GregorianCalendar();
cal.setTime( date.getTime() );
cal.add( Calendar.DAY_OF_MONTH, -30 );
Date d30 = cal.getTime();

Anyway I would try to perform this using only SQL.

answered Jan 16, 2012 at 9:20

stacker

69.1k29 gold badges143 silver badges214 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

ron Over a year ago

java.util.Date ts = (java.util.Date)mod.getValueAt(rowCount-1,1);

ron Over a year ago

myResult = statement .executeQuery("SELECT * FROM MYENERGYAPP.energytable9 WHERE MYDATETIME > "+ "{fn TIMESTAMPADD(SQL_TSI_MONTH, -1,timestamp('"+ts+"'))}");

ron Over a year ago

The above 2 comments were added before I intended - they are the solution I finally came up with.

dimo414 Over a year ago

@ron you can always submit your own answer to your question, rather than post a series of comments which are hard to format / read.

Collectives™ on Stack Overflow

java.sql.timestamp versus date

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related