I have added a column name month_added
, I run the query to extract the month from the date_added
column in my table but I get an error:
ERROR: column "date_added" does not exist
LINE 1: SELECT date_added, DATENAME (MONTH, date_added) ^
SQL state: 42703
Character: 8
ALTER TABLE movies
ADD month_added VARCHAR (50);
UPDATE movies
SET month_added = MONTH(date_added);
I have also tried the EXTRACT date function
CodePudding user response:
How to get month name from date in SQL Server
You can use the DateName
(tsql
) function: https://learn.microsoft.com/en-us/sql/t-sql/functions/datename-transact-sql?view=sql-server-ver16
Select DateName(Month, dateColumn) From test;
See also the linked SQL Fiddle: http://sqlfiddle.com/#!18/8fbf1/2