'I have a data set that has a column with hundreds of dates listed out like "August 21, 2020" and so on.I want to extract only the month (SQL) [closed]

enter image description here

Here is a snapshot of some of the data I am trying to extract only the month and place this into a new table. This is in SQL.

sqldate


Solution 1:[1]

select month(convert(date,<table_date>,101))

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 jarlh

Related Questions