数据库中的日期类型处理:Timestamp
<fmt:formatDate //只能承接java.unti.Date
Cannot convert of type class java.sql.Timestamp to class org.joda.time.DateTime
1,
Add this annotation on your DateTime field in your entity class
@Type(type="org.joda.time.contrib.hibernate.PersistentDateTime")
private DateTime birthDay;
And in your JSP, keep using the joda format tag:
<c:set var="formattedDateTimeValue">
<joda:format value="${DateTimeValue}" pattern="dd.MM.yyyy" />
<!-- Or any pattern you want -->
</c:set>
2,sql中采用to_char(T.WL_TIME,'yyyy-mm-dd hh24:mi:ss')//这种最省事