// 获取系统当前时间
long tima = System.currentTimeMillis();
Date today = new Date(tima);
// 转换时间格式
SimpleDateFormat sDateFormat = new SimpleDateFormat(“yyyy-MM-dd”);
long tima = System.currentTimeMillis();
Date today = new Date(tima);
// 转换时间格式
SimpleDateFormat sDateFormat = new SimpleDateFormat(“yyyy-MM-dd”);
String string = sDateFormat.format(today);
Oracle中TIMESTAMP类型数据与java中日期时间类型数据之间
sql1 = "SELECT * FROM OR where O_SENDTIME between to_date('"
+ first
+ "','yyyy-MM-dd') and to_date('"
+ end
+ "','yyyy-MM-dd') order by O_ID";