How to extract the month from the date_contact
column in SQL Server? I tried
SELECT dateadd(mm, datediff(mm, 0, date_contact), 0)
FROM cohort
and
select cast(date_contact As Date)
. I got a result that is the same as the date from the first query. And for the second query, I got the following error message:
date_contact
is not a valid name.
select datepart(mm,date_contact) from cohort
aka..
select month(date_contact) from cohort
or...
select datename(mm,date_contact) from cohort