本文介绍了在MySQL查询中将时间戳转换为日期的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想将MySQL中的timestamp转换为日期.
I want to convert a timestamp in MySQL to a date.
我想将user.registration字段的格式设置为yyyy-mm-dd.
I would like to format the user.registration field into the text file as a yyyy-mm-dd.
这是我的SQL:
$sql = requestSQL("SELECT user.email, info.name, FROM_UNIXTIME(user.registration), info.news FROM user, info WHERE user.id = info.id ", "export members");我还尝试了日期转换:
DATE_FORMAT(user.registration, '%d/%m/%Y') DATE(user.registration)我在写文本文件之前回显结果,我得到了:
I echo the result before to write the text file and I get :
email1; name1; DATE_FORMAT(user.registration,'%d/%m/%Y'); news1
email1;name1;DATE_FORMAT(user.registration, '%d/%m/%Y');news1
email2; name2; news2
email2;name2;news2
如何将该字段转换为日期?
How can I convert that field to date?
推荐答案DATE_FORMAT(FROM_UNIXTIME(`user.registration`), '%e %b %Y') AS 'date_formatted'
更多推荐
在MySQL查询中将时间戳转换为日期
发布评论