blocks|key|1400016|text|除了已经给出的建议之外，我还可以从你的问题中推断出另一种可能性：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1400017|你仍然希望结果是一个日期，你想“丢弃”天，小时，etcLeaving一个年/月的dateBut字段|1400018|SELECT
+++DATEADD(MONTH,+DATEDIFF(MONTH,+0,+<dateField>),+0)+AS+[year_month_date_field]
FROM
+++<your_table>|code-block|syntax|javascript|1400019|这将从基准日期(0)获取整月数，然后将其添加到该基准日期。因此向下舍入到日期所在的月份。|1400020|注意:在SQL+Server2008中，您仍然可以将时间附加为00:00:00.000，这与“删除”任何日期和时间的表示法并不完全相同。也是设置为第一天的日子。例如:+2009-10-01+00:00:00.000|1400021|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

As well as the suggestions given already, there is one other possiblity I can infer from your question: 
- You still want the result to be a date 
- But you want to 'discard' the Days, Hours, etc 
- Leaving a year/month only date field 

<pre><code>SELECT
 DATEADD(MONTH, DATEDIFF(MONTH, 0, &lt;dateField&gt;), 0) AS [year_month_date_field]
FROM
 &lt;your_table&gt;
</code></pre>

This gets the number of whole months from a base date (0) and then adds them to that base date. Thus rounding Down to the month in which the date is in.

NOTE: In SQL Server 2008, You will still have the TIME attached as 00:00:00.000
This is not exactly the same as "removing" any notation of day and time altogether.
Also the DAY set to the first. e.g. 2009-10-01 00:00:00.000

blocks|key|1399832|text|select+month(dateField),+year(dateField)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1399833|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>select month(dateField), year(dateField)
</code></pre>

blocks|key|1184546|text|SELECT+convert(varchar(7),+getdate(),+126)+|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1184547|你可能想看看这个网站：http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/|unstyled|offset|length|1184548|entityMap|0|LINK|mutability|MUTABLE|url|http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/^0|0|B|2G|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|R|8|@]|9|@$G|S|H|T|1|U]]|A|$]]|$1|I|3|-4|5|F|7|V|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P]]]]

<pre><code>SELECT convert(varchar(7), getdate(), 126) 
</code></pre>

You might wanna check out this website:
<a href="http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/" rel="noreferrer">http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/</a>

blocks|key|1399861|text|SELECT+DATEPART(yy,+DateVal)
SELECT+DATEPART(MM,+DateVal)
SELECT+DATENAME(MM,+DateVal)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1399862|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT DATEPART(yy, DateVal)
SELECT DATEPART(MM, DateVal)
SELECT DATENAME(MM, DateVal)
</code></pre>

blocks|key|1184568|text|datename(m,column)%2B'+'%2Bcast(datepart(yyyy,column)+as+varchar)+as+MonthYear|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1184569|输出将如下所示：‘2013年12月’|unstyled|1184570|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>datename(m,column)+' '+cast(datepart(yyyy,column) as varchar) as MonthYear
</code></pre>

the output will look like: 'December 2013'

blocks|key|1400121|text|这也是有帮助的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1400122|SELECT+YEAR(0),+MONTH(0),+DAY(0);|code-block|syntax|javascript|1400123|或|1400124|SELECT+YEAR(getdate()),+MONTH(getdate()),+DAY(getdate());|1400125|1400126|SELECT+YEAR(yourDateField),+MONTH(yourDateField),+DAY(yourDateField);|1400127|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Q|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|R|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|K|3|H|5|6|7|T|8|@]|9|@]|A|$]]|$1|L|3|M|5|D|7|U|8|@]|9|@]|A|$E|F]]|$1|N|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|O|$]]

This can be helpful as well.

<pre><code>SELECT YEAR(0), MONTH(0), DAY(0);
</code></pre>

or 

<pre><code>SELECT YEAR(getdate()), MONTH(getdate()), DAY(getdate());
</code></pre>

or 

<pre><code>SELECT YEAR(yourDateField), MONTH(yourDateField), DAY(yourDateField);
</code></pre>

blocks|key|1400267|text|某些数据库(如MS+ACCESS或RODBC+)可能不支持SQL+SERVER函数，但对于任何具有FORMAT函数的数据库，您只需执行以下操作：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1400268|SELECT+FORMAT(<your-date-field>,"YYYY-MM")+AS+year-date+FROM+<your-table>|code-block|syntax|javascript|1400269|entityMap^0|7|9|H|5|T|A|1D|6|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]|$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|L|$]]

Some of the databases such as <code>MS ACCESS</code> or <code>RODBC</code> may not support the <code>SQL SERVER</code> functions, but for any database that has the <code>FORMAT</code> function you can simply do this:

<pre><code>SELECT FORMAT(&lt;your-date-field&gt;,"YYYY-MM") AS year-date FROM &lt;your-table&gt;
</code></pre>

blocks|key|1184409|text|让我们这样写：YEAR(anySqlDate)和MONTH(anySqlDate)。例如，在YEAR(GETDATE())中尝试使用它。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1184410|entityMap^0|7|G|O|H|1A|F|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

let's write it this way: <code>YEAR(anySqlDate)</code> and <code>MONTH(anySqlDate)</code>. Try it with <code>YEAR(GETDATE())</code> for example.

blocks|key|1400029|text|convert(varchar(7),+<date_field>,+120)
because+120+results+in+'yyyy-MM-dd'+which+is+varchar(10)
using+varchar(7)+will+display+only+year+and+month

example:
select+convert(varchar(7),+<date_field>,+120),+COUNT(*)
from+<some_table>
group+by+convert(varchar(7),+<date_field>,+120)
order+by+1|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1400030|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>convert(varchar(7), &lt;date_field&gt;, 120)
because 120 results in 'yyyy-MM-dd' which is varchar(10)
using varchar(7) will display only year and month

example:
select convert(varchar(7), &lt;date_field&gt;, 120), COUNT(*)
from &lt;some_table&gt;
group by convert(varchar(7), &lt;date_field&gt;, 120)
order by 1
</code></pre>

blocks|key|1184585|text|RIGHT(CONVERT(VARCHAR(10),+reg_dte,+105),+7)+|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1184586|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>RIGHT(CONVERT(VARCHAR(10), reg_dte, 105), 7) 
</code></pre>

blocks|key|1400112|text|尝尝这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1400113|select+to_char(DATEFIELD,'MON')+from+YOUR_TABLE|code-block|syntax|javascript|1400114|例如：|1400115|select+to_char(sysdate,+'MON')+from+dual|1400116|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Try this

<pre><code>select to_char(DATEFIELD,'MON') from YOUR_TABLE
</code></pre>

eg.

<pre><code>select to_char(sysdate, 'MON') from dual
</code></pre>

blocks|key|1184635|text|CONCAT+(datepart+(yy,DATE),+FORMAT+(DATE,'MM'))+|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1184636|如果你想要一个六位数的结果，会给你例如201601|unstyled|1184637|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>CONCAT (datepart (yy,DATE), FORMAT (DATE,'MM')) 
</code></pre>

gives you eg 201601 if you want a six digit result

blocks|key|1400432|text|select+CONCAT(MONTH(GETDATE()),'.',YEAR(GETDATE()))
Output:+**5.2020**

select+CONCAT(DATENAME(MONTH+,+GETDATE()),'.',YEAR(GETDATE()))
Output:+**May.2020**|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1400433|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>select CONCAT(MONTH(GETDATE()),'.',YEAR(GETDATE()))
Output: **5.2020**

select CONCAT(DATENAME(MONTH , GETDATE()),'.',YEAR(GETDATE()))
Output: **May.2020**
</code></pre>

blocks|key|1184924|text|我有一个特定的要求，需要做一些类似的事情，它将显示月-年，可以通过以下方式完成：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1184925|SELECT+DATENAME(month,+GETDATE())+%2B+'-'+%2B++CAST(YEAR(GETDATE())+AS+nvarchar)+AS+'Month-Year'|offset|length|style|CODE|1184926|在我的特殊情况下，我需要将其简化为3个字母的月份缩写，并使用2位数的年份，如下所示：SELECT+LEFT(DATENAME(month,+GETDATE()),+3)+%2B+'-'+%2B++CAST(RIGHT(YEAR(GETDATE()),2)+AS+nvarchar(2))+AS+'Month-Year'|1184927|entityMap^0|0|0|2K|0|16|35|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@$D|Q|E|R|F|G]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|K|$]]

I had a specific requirement to do something similar where it would show month-year which can be done by the following: 

<code>SELECT DATENAME(month, GETDATE()) + '-' + CAST(YEAR(GETDATE()) AS nvarchar) AS 'Month-Year'</code>

In my particular case, I needed to have it down to the 3 letter month abreviation with a 2 digit year, looking something like this: 
<code>SELECT LEFT(DATENAME(month, GETDATE()), 3) + '-' + CAST(RIGHT(YEAR(GETDATE()),2) AS nvarchar(2)) AS 'Month-Year'</code>

blocks|key|1400422|text|试试SELECT+CONCAT(month(datefield),+'.',+year(datefield))+FROM+YOURTABLE;|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1400423|entityMap^0|2|1X|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Try <code>SELECT CONCAT(month(datefield), '.', year(datefield)) FROM YOURTABLE;</code>

blocks|key|1400508|text|另一个简单的答案是从日期中删除天数|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1400509|下面是如何在BigQuery中执行此操作|1400510|SELECT+DATE_ADD(<date_field>,+INTERVAL+1+-+extract(day+from+<date_field>)+DAY)+as+year_month_date|code-block|syntax|javascript|1400511|举个例子：|1400512|SELECT+DATE_ADD(date+'2021-03-25',+INTERVAL+1+-+extract(day+from+date+'2021-03-25')+DAY)+as+year_month_date|1400513|此返回2021-03-01|offset|length|style|CODE|1400514|entityMap^0|0|0|0|0|0|3|A|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|Z|8|@$O|10|P|11|Q|R]]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

Another simple answer is to remove the number of day from the date
Here how to do it in BigQuery
<pre><code>SELECT DATE_ADD(&lt;date_field&gt;, INTERVAL 1 - extract(day from &lt;date_field&gt;) DAY) as year_month_date
</code></pre>
An exemple :
<pre><code>SELECT DATE_ADD(date '2021-03-25', INTERVAL 1 - extract(day from date '2021-03-25') DAY) as year_month_date
</code></pre>
This return <code>2021-03-01</code>

blocks|key|1400613|text|出于报告目的，我倾向于使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1400614|CONCAT(YEAR([DateColumn]),+RIGHT(CONCAT('00',+MONTH([DateColumn])),+2))|code-block|syntax|javascript|1400615|您将丢失date类型，因为这将返回(n)varchar。但是有了前导零，这一列是可排序的(例如'202112‘>+'202102')。您还可以在年份和月份之间添加分隔符，如下所示|1400616|CONCAT(YEAR([DateColumn]),+'-',+RIGHT(CONCAT('00',+MONTH([DateColumn])),+2))|1400617|返回一些像'2020-08‘(仍然可以排序)的想法。|1400618|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

For reporting purposes I tend to use
<pre><code>CONCAT(YEAR([DateColumn]), RIGHT(CONCAT('00', MONTH([DateColumn])), 2))
</code></pre>
You will lose the date type, since that will return (n)varchar. But with the leading zero this column is sortable (e.g. '202112' &gt; '202102'). You could also add a seperator between year and month like
<pre><code>CONCAT(YEAR([DateColumn]), '-', RIGHT(CONCAT('00', MONTH([DateColumn])), 2))
</code></pre>
returning somethink like '2020-08' (still sortable).

blocks|key|1185180|text|对于MySQL来说，这很好用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1185181|DATE_FORMAT(<your-date>,+'%25Y-%25m+%25M')|code-block|syntax|javascript|1185182|它进入SELECT语句。下面是输出：|offset|length|style|CODE|1185183|2014-03+March|1185184|有关DATE_FORMAT的更多信息，请查看文档：https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format|1185185|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format^0|0|0|3|6|0|0|2|B|P|2H|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@$I|11|J|12|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|14|8|@$I|15|J|16|K|L]]|9|@$I|17|J|18|1|19]]|A|$]]|$1|Q|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

For MySQL, this works pretty well:
<pre><code>DATE_FORMAT(&lt;your-date&gt;, '%Y-%m %M')
</code></pre>
It goes into the <code>SELECT</code> statement. Here's the output:
<pre><code>2014-03 March
</code></pre>
For more information about <code>DATE_FORMAT</code>, check out the documentation:
<a href="https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format</a>

blocks|key|1184663|text|我的数据库不支持上面的大多数函数，但是我发现这是可行的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1184664|SELECT+*+FROM+table+WHERE+SUBSTR(datetime_column,+starting_position,+number_of_strings)=required_year_and_month;|offset|length|style|CODE|1184665|例如：SELECT+SUBSTR(created,+1,7)+FROM+table;|1184666|以"yyyy-mm“格式返回年份和月份|1184667|entityMap^0|0|0|34|0|3|13|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@$D|S|E|T|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|M|$]]

My database doesn't support most of the functions above however I found that this works:

<code>SELECT * FROM table WHERE SUBSTR(datetime_column, starting_position, number_of_strings)=required_year_and_month;</code> 

for example:
<code>SELECT SUBSTR(created, 1,7) FROM table;</code> 

returns the year and month in the format "yyyy-mm"

blocks|key|1184713|text|select+convert(varchar(11),+transfer_date,+106)+|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1184714|得到了格式为2018年3月7日的日期的预期结果|unstyled|1184715|我的列'transfer_date‘是datetime类型的列，并且我在azure上使用SQL+Server2017|1184716|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|F|7|N|8|@]|9|@]|A|$]]]|J|$]]

<pre><code>select convert(varchar(11), transfer_date, 106) 
</code></pre>

got me my desired result of date formatted as 07 Mar 2018

My column 'transfer_date' is a datetime type column and I am using SQL Server 2017 on azure

blocks|key|1184780|text|结果："YYYY-MM“|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1184781|SELECT+cast(YEAR(<DateColumn>)+as+varchar)+%2B+'-'+%2B+cast(Month(<DateColumn>)+as+varchar)|code-block|syntax|javascript|1184782|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For result: "YYYY-MM" 

<pre><code>SELECT cast(YEAR(&lt;DateColumn&gt;) as varchar) + '-' + cast(Month(&lt;DateColumn&gt;) as varchar)
</code></pre>

blocks|key|1400334|text|查询:-+Select+datename(m,GETDATE())%2B'-'%2Bcast(datepart(yyyy,GETDATE())+as+varchar)+as+FieldName|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1400335|产出:-+2019年1月|1400336|我们可以使用的常规日期字段|1400337|datename(m,<DateField>)%2B'+'%2Bcast(datepart(yyyy,<DateField>)+as+varchar)+as+FieldName|code-block|syntax|javascript|1400338|entityMap^0|5|2F|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|T|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|U|8|@]|D|@]|E|$]]|$1|J|3|K|5|L|7|V|8|@]|D|@]|E|$M|N]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

Query :- <code>Select datename(m,GETDATE())+'-'+cast(datepart(yyyy,GETDATE()) as varchar) as FieldName</code>

Output :- January-2019

general datefield we can use

<pre><code>datename(m,&lt;DateField&gt;)+' '+cast(datepart(yyyy,&lt;DateField&gt;) as varchar) as FieldName
</code></pre>

blocks|key|1400355|text|SELECT+REPLACE(RIGHT(CONVERT(VARCHAR(11),+GETDATE(),+106),+8),+'+',+'-')|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1400356|输出:2019年3月|unstyled|1400357|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>SELECT REPLACE(RIGHT(CONVERT(VARCHAR(11), GETDATE(), 106), 8), ' ', '-')
</code></pre>

Output: Mar-2019

blocks|key|1185131|text|SELECT+*+FROM+demo+
++++WHERE+attendance_year_month+<+SUBSTRING(CURRENT_TIMESTAMP,1,11)+
++++++++++AND
++++++++++attendance_year_month+>=+DATE_SUB(SUBSTRING(CURRENT_TIMESTAMP,1,11),+INTERVAL+6+MONTH)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1185132|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre class="lang-sql prettyprint-override"><code>SELECT * FROM demo 
 WHERE attendance_year_month &lt; SUBSTRING(CURRENT_TIMESTAMP,1,11) 
 AND
 attendance_year_month &gt;= DATE_SUB(SUBSTRING(CURRENT_TIMESTAMP,1,11), INTERVAL 6 MONTH)
</code></pre>

问仅从SQL DATE获取月份和年份
EN

回答 24

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问仅从SQL DATE获取月份和年份EN

回答 24

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问仅从SQL DATE获取月份和年份
EN