MySQL-选择多少“天数"一个领域是 [英] MySQL - Selecting how many "Days Old" a field is

问题描述

如何根据"DateAdded"字段选择字段的保留天数?

How can I select how many days old a field is based on it's "DateAdded" field?

例如:

SELECT DAYSOLD(tbl_stuff.DateAdded) as DaysOld 
  FROM tbl_stuff

推荐答案

使用:

SELECT DATEDIFF(NOW(), ts.dateadded) AS daysold
  FROM TBL_STUFF ts

参考: DATEDIFF

DATEDIFF()返回expr1 – expr2，表示为从一个日期到另一个日期的天数.

DATEDIFF() returns expr1 – expr2 expressed as a value in days from one date to the other.

这篇关于MySQL-选择多少“天数"一个领域是的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！