SQL

get month of date sql

-- Using MONTH() and GETDATE() function to fetch current month
SELECT MONTH(getdate()) AS "Present Month";

-- Using DATEPART() function and GETDATE() function
SELECT DATEPART(MONTH, GETDATE()) as "Present Month Of the Year";

-- Getting the name of the current month
SELECT FORMAT(GETDATE(),'MMMM') AS Month;

sql date get month

-- Will return 'November'
select to_char(to_date('15-11-2010', 'DD-MM-YYYY'), 'Month') from dual

sql get month from date

-- Month of today example:
SELECT MONTH(GETDATE()) AS Month;

how to extract only year and month from date in sql

SELECT FORMAT(<your-date-field>,"YYYY-MM") AS year-date FROM <your-table>

how to select month from date in sql

SELECT Month('2022/03/17') AS Month;

sql get month and year from date

DECLARE @date date = '04-18-2020' --date for act;
SELECT YEAR(date), MONTH(date)    --, DAY(date) add if u want day

sql date with month and year only

SELECT
   DATEADD(MONTH, DATEDIFF(MONTH, 0, <dateField>), 0) AS [year_month_date_field]
FROM
   <your_table>

get month from date sql server

----SQL Server
--Setup
CREATE TABLE Users
    ([name] varchar(100), [creationDate] datetime)
;
INSERT 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