Get month from date sql server

get month from date sql server

----SQL Server
--Setup
CREATE TABLE IF NOT EXISTS Users
    ([name] varchar(100), [creationDate] datetime)
;
INSERT IGNORE INTO Users
    ([name], [creationDate])
VALUES
    ('Alice', CAST('2021-12-31T12:34:56' AS DATETIME)),
    ('Bob', GETDATE())
;

--Get month
SELECT DATEPART(MM, u.creationDate)
FROM Users u