Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
C
C
chopik252022-01-05 21:07:46
SQL
chopik25, 2022-01-05 21:07:46

How to get only the year from a date?

The table has a column with the publication date 2022-01-01 22:08:43. How to get only a year?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
S
Stalker_RED, 2022-01-05
@Stalker_RED

SELECT id, YEAR(colName) FROM tblName

Similar questions
S
Sanzhar Bazarbek2021-04-04 12:35:40
How to remove blur from an image? 2Reply
N
NyxDeveloper2021-05-04 16:15:55
How to forbid assigning id to fields of ForignKey of that object, whose certain field is equal to False? 4Reply
O
Oleg Petrov2017-10-12 11:43:04
Why doesn't the list transformation function work? 6Reply
K
Kamil2020-03-19 10:33:29
How to extract information from habr? 3Reply
U
Username2015-04-21 14:45:15
What should be the SQL query syntax in php? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question