to_char(a.create_date,'yyyy-MM-dd HH:MI AM')
//解析日期数据
SimpleDateFormat sdfTime = new SimpleDateFormat("yyyy-MM-dd hh:mm aaa");
String data = "1900-11-10 5:09 PM"
targetCell.setCellValue(sdfTime.parse(data));
//String --> Date格式
Timestamp valueOf(String s)
String s = "1970-11-10";// format yyyy-mm-dd hh:mm:ss.fffffff(纳秒)
Timestamp ts = Timestamp.valueOf(s)
//Calendar日历
Calendar c = Calendar.getInstance();
//TimeZone时区
Calendar cJapan = new GregorianCalendar(TimeZone.getTimeZone("Japan"));
System.out.println(cJapan.get(Calendar.HOUR_OF_DAY));
[img]http://dl2.iteye.com/upload/attachment/0117/1959/f13f5c50-507c-3d2e-86a6-ed5470448dbd.png[/img]