查询从datetime转换为日期mysql [英] Query to convert from datetime to date mysql

问题描述

我正在尝试获取datetime字段的日期部分。我知道我可以用date_format来获取它，但是这会返回一个字符串或varchar字段。如何将结果转换为日期而不是varchar？

I am trying to get the date portion of a datetime field. I know I can get it with date_format, but that returns a string or "varchar" field. How can I convert the result to date and not as varchar?

这是我返回varchar的查询：

This is my query returning the varchar:

(Select Date_Format(orders.date_purchased,'%m/%d/%Y')) As Date  

我尝试了这个问题的几个组合，但是无法使其工作：

I tried several combinations from this question, but could not make it to work:

mysql查询 - 输出格式日期？

任何

推荐答案

尝试将其转换为日期

SELECT CAST(orders.date_purchased AS DATE) AS DATE_PURCHASED

这篇关于查询从datetime转换为日期mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！