java - 获取 mysql 中两天之间的天数名称

Question

MySql 中是否有任何方法可以返回两个日期之间的天数名称。例如，06/11/207 是开始日期，12/11/2017 是结束日期，那么我需要将输出获取为:

monday,tuesday,wednesday,thursday,friday,saturday,sunday

Answer 1

你可以试试这个:

您可以从此链接获取 F_TABLE_NUMBER_RANGE 函数:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47685

declare @start_date     datetime
declare @end_date       datetime
declare @days           int

select @start_date  = '06/11/2017'
select @end_date    = '12/11/2017'

select @days = datediff(dd,@start_date,@end_date) +1

select
    [Date]      = dateadd(dd,number-1,@start_date),
    [Day of Week]   = datename(weekday,dateadd(dd,number-1,@start_date))
from
    dbo.F_TABLE_NUMBER_RANGE( 1, @days )
order by
    number

这我已经尝试过了，为我干杯!