प्राप्त माह से तारीख sql सर्वर

कोड उदाहरण

0
0

प्राप्त माह से तारीख sql सर्वर

----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

इसी तरह के पन्ने

उदाहरणों के साथ समान पृष्ठ

अन्य भाषाओं में

यह पृष्ठ अन्य भाषाओं में है

Русский
..................................................................................................................
English
..................................................................................................................
Italiano
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
中文
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................
Балгарскі
..................................................................................................................
Íslensk
..................................................................................................................

इस श्रेणी में लोकप्रिय

श्रेणी में उदाहरण के साथ लोकप्रिय पृष्ठों