Question

我有几个日期,用这些日期来找出这个月的天数。如果我有2003-02-05,它应该返回28天,例如28天。

date                days_in_month
2003-2-3            28

Answer 1

SELECT DAY(LAST_DAY(yourdate))

Answer 2

尝试此 :

SELECT DAYOFMONTH(LAST_DAY(your_date)) FROM your_table

Answer 3

您可以将上天日与字符串函数结合

SELECT RIGHT( LAST_DAY(   2003-02-03  ) , 2 )

Answer 4

尝试

select DAY(LAST_DAY(yourdate)) as days_in_month

Answer 5

以下列方式替代字符串购物:

SELECT DAY(LAST_DAY( 2010-02-1 ));

Answer 6

声明之后的用途

SELECT DAY(LAST_DAY(now()))

Answer 7

I think you are asking the total number of days to be returned for a month. If you are trying to find the total number of days for current month, here is the query:

select timestampdiff(day,
concat(year(now()), - ,month(now()), -01 ),
date_add( concat(year(now()), - ,month(now()), -01 ), interval 1 month)).

如果您想要使用任何编程语言将它外部化, 请在代码中外部化年月, 代之以现在( )

友情链接