sql - how to find out number of days in month in mysql

Question

Welcome To Ask or Share your Answers For Others

sql - how to find out number of days in month in mysql

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

I have several dates in mysql tables, using those dates I need to find out the number of days in the month. Suppose i have 2003-02-05 it should return 28. for example

date                days_in_month
2003-2-3            28

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

384 views

1 Answer

深蓝 · Answer 1 · 2021-10-23T17:48:35+0000

answered Oct 24, 2021 by 深蓝 (71.8m points)

SELECT DAY(LAST_DAY(yourdate))

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

Categories

sql - how to find out number of days in month in mysql

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

Please log in or register to add a comment.

Just Browsing Browsing

Most popular tags