在给定的两个日期之间获取月份名称 [英] To get months name between given two dates

问题描述

我有两个日期，如1. 01/01/2014

和2. 01/03/2014



我必须得到输出JAN，FEB和MAR

Hi,
I have two dates like 1. 01/01/2014
and 2. 01/03/2014

I have to get output JAN,FEB AND MAR

推荐答案

试试这个 -

Try this-

DECLARE @Date1 DATETIME
DECLARE @Date2 DATETIME

SET @Date1='2014-01-01'
SET @Date2='2014-03-01'

DECLARE @Result VARCHAR(100)
SET @Result=''
WHILE (@Date1<=@Date2)
BEGIN
    IF(@Result!='') SET @Result+=','
    SELECT @Result+=UPPER(LEFT(DATENAME(MONTH,@Date1),3))
    SET @Date1=DATEADD(MONTH,1,@Date1)
END

SELECT @Result

除了Shwe ta Nikhil Mishra

我更新了查询

In Addition to Shweta Nikhil Mishra
I have update the query

Declare @FromDate Date='01/01/2014'
Declare @ToDate Date='03/01/2014'

 create table #temp( MonthsName varchar(50));
While @ToDate>=@FromDate
BEGIN


insert into #temp values(DateName(MM,@FromDate))
set @FromDate=DateAdd(mm,1,@FromDate)

END

select * from #temp
drop table #temp

试试这个

Try This

Declare @FromDate Date='01/01/2014'
Declare @ToDate Date='03/01/2014'

While @ToDate>=@FromDate
BEGIN

Select DateName(MM,@FromDate)

set @FromDate=DateAdd(mm,1,@FromDate)

END

这篇关于在给定的两个日期之间获取月份名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！