Compare date with current date in java using sql

Question

I am trying to compare a SQL date with the current date.

I figured out how to compare two SQL dates but I couldn't extract the current date.

java.sql.Date xxx = new java.sql.Date(jdatechooser1.getDate().getTime());
java.sql.Date yyy = new java.sql.Date(jdatechooser2.getDate().getTime());

if (yyy.after(xxx)) {
    System.out.println("ok");
}

the problem is sqldate doesn't have such constructor date() !!! — Dali Landoulsi
– Dali Landoulsi, Commented Mar 23, 2016 at 11:50
new java.util.Date().after(xxx), you can use a fully qualified name instead. This is not a new problem — MadProgrammer
– MadProgrammer, Commented Mar 23, 2016 at 12:00

Ludovic Frérot · Accepted Answer · 2016-03-23 12:35:51Z

3

Uses the system date instead: System.currentTimeMillis()

java.sql.Date dateToBeChecked= new java.sql.Date(jdatechooser1.getDate().getTime());
java.sql.Date systemDate = new java.sql.Date(System.currentTimeMillis());

if(dateToBeChecked.after(systemDate)){
    System.out.println("ok");
}

But since it's long values you don't need to transform anything to an object and can do this instead:

if(jdatechooser1.getDate().getTime() > System.currentTimeMillis()){
  System.out.println("ok");
}

edited Mar 23, 2016 at 12:35

answered Mar 23, 2016 at 12:18

Ludovic Frérot

6054 silver badges9 bronze badges

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

Comments

rdonuk · Accepted Answer · 2016-03-23 12:02:29Z

2

At first you must create a java.util.Date object with empty constructor. Then give the long value which can be get by getTime() method, to the java.sql.Date constructor.

java.sql.Date date = new java.sql.Date(new java.util.Date().getTime());

edited Mar 23, 2016 at 12:02

answered Mar 23, 2016 at 11:50

rdonuk

3,94624 silver badges42 bronze badges

Collectives™ on Stack Overflow

Compare date with current date in java using sql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related