sql 处理时间格化

函数 FROM_UNIXTIME(createDate/1000,'%Y-%m-%d')

例子:

     select
        FROM_UNIXTIME(createDate/1000,'%Y-%m-%d')
        from teacher_learn_record
        where userId = 1047455 and `status` = 0
        GROUP BY FROM_UNIXTIME(createDate/1000,'%Y-%m-%d')