本文介绍了MySQL:如何计算从特定日期算起的星期数?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要从MySQL select语句中的某个日期开始计算周数.其中一个表中有一个日期列,我需要计算该日期有几周.
I need to calculate the weeks out from a date in my MySQL select statement. There is a date column in one of the tables, and I need to calculate how many weeks away the date is.
SELECT EventDate, (calculation) AS WeeksOut FROM Events;示例:
- 6天之内,周数= 0
- 7天之内,几周= 1
- 13天之内,几周= 1
- 14天之内,几周= 2
使用 DATEDIFF函数:
ROUND(DATEDIFF(end_date, start_date)/7, 0) AS weeksoutWEEKS的问题在于,对于跨越1月1日的日期,它不会返回正确的结果.
The problem with WEEKS is that it won't return correct results for dates that cross over January 1st.
0是 ROUND 函数.
更多推荐
MySQL:如何计算从特定日期算起的星期数?
发布评论