public Date getLastSynTime() { Date lastSynTime = null; try { String sql = "select to_char(SYN_DATE,'yyyy-MM-dd HH:mm:ss') from SHOP_TRADES_SYN_TIME_T order by SYN_DATE desc"; SQLQuery query = getSession().createSQLQuery(sql); query.setMaxResults(1); String resultDate = (String) query.uniqueResult(); java.text.SimpleDateFormat format = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); lastSynTime = format.parse(resultDate); } catch (Exception ex) { lastSynTime = DateUtils.addDays(new Date(), -7); //减7天 ex.printStackTrace(); } return lastSynTime; } 附上更多的对时间的应用: public static final FastDateFormat FAST_SECOND_FORMATETR = FastDateFormat.getInstance("yyyy-MM-dd HH:mm:ss"); /* 格式化日期为短形式 */ public static String getShortDate(Date myDate){ return FAST_SECOND_FORMATETR.format(myDate); } /* 格式化日期为标准形式 */ public static String formatDateTime(Date myDate, String pattern) { FastDateFormat format = FastDateFormat.getInstance(pattern); return format.format(myDate); } //在Common-lang中的DateUtils类的使用 /** * 返回date时间 只到天 2008-05-20 00:00 * * @param date * @return */ public static Date getNoHHMMDate(Date date) { return org.apache.commons.lang.time.DateUtils.truncate(date, Calendar.DATE); } /** * 增加天 * @param date * @param i * @return */ public static Date addDays(Date date, int i) { return org.apache.commons.lang.time.DateUtils.addDays(date, i); }