SELECT *,FROM_UNIXTIME(CREATE_TIME,'%Y-%m-%d %H:%i:%s') AS CREATE_TIME_TRAN FROM cp_information WHERE INFORMATION_TYPE_ID=1 LIMIT 0,8;
转换对应效果:
[
{
"CREATE_TIME" : "1526024279",
"CREATE_TIME_TRAN" : "2018-05-11 15:37:59"
},
{
"CREATE_TIME" : "1526024279",
"CREATE_TIME_TRAN" : "2018-05-11 15:37:59"
},
{
"CREATE_TIME" : "1526024279",
"CREATE_TIME_TRAN" : "2018-05-11 15:37:59"
},
{
"CREATE_TIME" : "1526024279",
"CREATE_TIME_TRAN" : "2018-05-11 15:37:59"
},
{
"CREATE_TIME" : "1526024279",
"CREATE_TIME_TRAN" : "2018-05-11 15:37:59"
},
{
"CREATE_TIME" : "1526024279",
"CREATE_TIME_TRAN" : "2018-05-11 15:37:59"
},
{
"CREATE_TIME" : "1526024279",
"CREATE_TIME_TRAN" : "2018-05-11 15:37:59"
},
{
"CREATE_TIME" : "1526024279",
"CREATE_TIME_TRAN" : "2018-05-11 15:37:59"
}
]