Oracle时间比较

select * from table where testDate>=to_date('"+startDate+"','yyyy-mm-dd')";
startDate为字符，将它转为DATE格式进行比较。

String DateOne=sdf.format(t.getDateOne());
String DateTwo=sdf.format(t.getDateTwo());
java.util.Calendar c1=java.util.Calendar.getInstance();
java.util.Calendar c2=java.util.Calendar.getInstance();
java.text.DateFormat df=new java.text.SimpleDateFormat("yyyy-MM-dd");
c1.setTime(df.parse(DateOne));
c2.setTime(df.parse(DateTwo));
   if(c1.compareTo(c2)<0)
   {
      System.out.println("c1小于c2");
   }
   else if(c1.compareTo(c2)>0)
   {
      System.out.println("c1大于c2");
   }
   else
   {
      System.out.println("c1等于c2");

   }