当前日期和日期字段之间的天数 [英] Number of days between current date and date field

问题描述

如果有人可以帮助，我就会遇到这个问题. 表(table1)中有一个字段(date)，它是格式为3/31/1988 (M/D/y)的日期，我需要定义自该日期以来已经过了多少天.

I have this problem if anyone can help. There is a field (date) in my table (table1) that is a date in the format 3/31/1988 (M/D/y), and my necessity is to define how many days have passed since that date.

我试图给出此指示

SELECT DATEDIFF(CURDATE(), date) AS days
FROM table1

但是它会返回'null'，我认为这是因为两种日期格式不同(CURDATE()是YMD .....

But it gives back 'null' and I think this happens because the two date formats are different (CURDATE() is YMD.....

对吗?谁能帮我? 预先谢谢你

Is it correct? can anyone help me? Thank you in advance

推荐答案

您可以使用

You can use STR_TO_DATE():

SELECT DATEDIFF(CURDATE(),STR_TO_DATE(date, '%m/%d/%Y')) AS days
FROM table1

SQLFiddle演示

这篇关于当前日期和日期字段之间的天数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！