Answers for "get month from date sql server"

SQL

0

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

Posted by: Guest on April-01-2022

Code answers related to "get month from date sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#