截断MySQL查询中的datetime列 [英] Truncate datetime column in MySQL query

问题描述

我有一个列正在用作使用此格式的选择的一部分(2011-09-28 14:51:59).如何删除时间元素，仅将日期保留在查询中?

I have a column I am using as part of a select that uses this format (2011-09-28 14:51:59). How do I remove the time element and just keep the date all within my query?

SELECT PictureModifiedDateTime AS FILE_DATE WHERE column = "blah"

推荐答案

尝试一下

SELECT DATE_FORMAT(PictureModifiedDateTime,'%y-%m-%d') AS FILE_DATE WHERE column = "blah"

或使用日期

SELECT DATE(PictureModifiedDateTime) AS FILE_DATE WHERE column = "blah"

这篇关于截断MySQL查询中的datetime列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！