如何从SQL中的日期字段中提取月份 [英] How to extract month on from the date field in SQL

问题描述

我的表格中有一个日期字段名称为InvoiceDate，其日期信息如此20140231，我想从该日期字段中获取月份，以便我可以按季度对记录进行分组，请参阅附件我试过的查询，目前日期字段是硬编码的，如您在查询中看到的那样。

请帮助我如何获得此记录中的月份

I have a date field name as "InvoiceDate" in my table that have a date information like this "20140231", I want to get the month out of that date field so that I can group my record per quarter see the attached query that I tried, currently the date field is hard coded as you see on the query.
Can you please help how can I get the month on this record

"20140231", 

我的尝试：



这是我试过的东西

What I have tried:

This what I tried

SELECT TOP 1000 [Advise no]
      ,[Amount]
      ,[Date]
      ,[Bas Fund Description]
	  ,[Invoice Date]
         (MONTH, DATEDIFF(MONTH, 0, [Invoice Date]), 0) AS months
	   , CASE WHEN [Invoice Date] BETWEEN 20170401 AND 20170631
             THEN 'Q1' 
           WHEN [Invoice Date] BETWEEN 20170701 AND 20170931
             THEN 'Q2' 
           WHEN [Invoice Date] BETWEEN 20171001 AND 20171231
             THEN 'Q3'
           WHEN [Invoice Date] BETWEEN 20180101 AND 20180331 
              THEN 'Q4' 
           WHEN [Invoice Date] Is Null 
              THEN 'Null' 

        END AS QuarterPeriod 
      ,[Valuation Date]
      ,[qgs_geometry]
      ,[qgs_fid]
      ,[ProvinceName]
  FROM [DOD].[dbo].[View_DPW_PACE]

推荐答案

SELECT MONTH('2014-02-31')

请参阅： MONTH（Transact-SQL）| Microsoft Docs [ ^ ]

这篇关于如何从SQL中的日期字段中提取月份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！