mysql 转换为datetime类型,将MySql DateTime类型转换为更友好的东西

I have a Java web app that reads a MySql db and returns DateTime fields. What is the best way to convert the DateTime fields returned in the resultset into something more readable?

Currently the DateTime fields print as:

2008-12-14 16:30:00

but I would like something more user friendly like:

14 Dec 2008 at 16:30

I am populating an ArrayList with these dateTimes from a pojo. I would like to format them before adding to the arrayList, so then I can just print the contents of the arrayList in the JSP.

解决方案

Another option is to use the JSTL. The formatting library makes it easy to display a date in any format and it is i18n aware. The advantage is that you can leave the date as a Date object and manipulate it as such but only convert it when you need to display. The format tag will look like this:

Like I said above, one big advantage is that it is i18n aware so you can display the date in a localized format.

The full syntax is:

timeZone="expression"

type="field" dateStyle="style"

timeStyle="style"

pattern="expression"

var="name" scope="scope"/>