java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("yyyy-mm-dd hh:mm:ss"); java.util.Date date = new java.util.Date(); System.out.println(sdf.format(date)); 获得系统当前标准格式的时间
用chengchaog()的方法得到的是字符串,查询还是有错,是不是用字符串不能比较时间啊?下面是我的hql代码,看看有什么问题吗? SimpleDateFormat formatter = new SimpleDateFormat ("yyyy-MM-dd HH:mm:ss"); Date date=new Date(); String start=formatter.format(date); String end=formatter.format(date);"FROM EmailInfo as email where email.creatTime >= "+start+" and email.creatTime<="+end+ " or email.receivedTime >= "+start+" and email.receivedTime<="+end;
java.util.Date date = new java.util.Date();
System.out.println(sdf.format(date));
获得系统当前标准格式的时间
SimpleDateFormat formatter = new SimpleDateFormat ("yyyy-MM-dd HH:mm:ss");
Date date=new Date();
String start=formatter.format(date);
String end=formatter.format(date);"FROM EmailInfo as email where email.creatTime >= "+start+" and email.creatTime<="+end+
" or email.receivedTime >= "+start+" and email.receivedTime<="+end;
数据库的日期最好是手动转换 ,因为日期保存在数据库里的格式有几种
比如 小时 有0-23 有1-24 有12小时3种
oracle 将"+start+" 改成todate('yyyy-mm-dd hh24:mi:ss','"+start+"' )