mysql 日期类型转换 急！！！

Question

我的数据库是mysql的 有个字段 是datetime类型 ，读取后 显示
java.util.GregorianCalendar[time=1243402015000,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Asia/Shanghai",offset=28800000,dstSavings=0,useDaylight=false,transitions=19,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2009,MONTH=4,WEEK_OF_YEAR=22,WEEK_OF_MONTH=5,DAY_OF_MONTH=27,DAY_OF_YEAR=147,DAY_OF_WEEK=4,DAY_OF_WEEK_IN_MONTH=4,AM_PM=1,HOUR=1,HOUR_OF_DAY=13,MINUTE=26,SECOND=55,MILLISECOND=0,ZONE_OFFSET=28800000,DST_OFFSET=0]这么长一堆的数据 怎么转化成java的date 或是string类型的日期啊。。高手帮忙！！！！！

Answer 1

select DATE_FORMAT(date,format) from table参考资料：
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

Answer 2

多谢 。问题解决 date_format( question.submitDate, '%Y-%m-%d %H:%i:%s') 分享一下。

Answer 3

但是 我还想学习一下用 java编程怎么转换呢 高手指教