日期:2014-05-16  浏览次数:20688 次

mysql查询java时间戳类型转换成日期类型的内置函数
select f.`id` as '文件ID',f.`file_path` as '文件名',from_unixtime(f.`lastModifyTime`/1000) as '上传时间',f.`download_count` as '下载次数' from dfs_file f where f.`lastModifyTime`>1309146844777 and f.`download_count`>0 order by f.`download_count` desc
?

?