MySql时间格式转化

今天想把数据库的数据按小时分组，查询sql主要如下：

 

SELECT date from ((SELECT
                DATE_FORMAT( a.create_date,"%Y-%m-%d %H") AS "date"
        FROM
            user_info a
        where
            a.del_flag = "0"
       GROUP BY DATE_FORMAT(a.create_date,"%Y-%m-%d %H")

 

但是在获取list的时候，程序报出如下错误：

 

Bad format for Timestamp '2017-11-28 14' in column 1.
    at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1378) ~[mysql-connector-java-5.1.30.jar:na]
    at com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:127) ~[mysql-connector-java-5.1.30.jar:na]
    at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6587) ~[mysql-connectorjava-5.1.30.jar:na]
    at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6187) ~[mysql-connector-java-5.1.30.jar:na]
    at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6225) ~[mysql-connector-java-5.1.30.jar:na]
    at com.alibaba.druid.filter.FilterChainImpl.resultSet_getTimestamp(FilterChainImpl.java:909) ~[druid-1.0.11.jar:1.0.11]

原因：“2017-11-28 14” 格式的时间戳，Date类型。
 

学习圣经，青年程序员团契，V信：A769506