Difference between revisions of "SQL - Extract month from current date"

(Created page with "If you want to extract the month of the current date directly, then use ''CURRENT_TIMESTAMP'' <pre>SELECT EXTRACT(MONTH FROM CURRENT_TIMESTAMP)</pre> Category: SQL")
(No difference)

Revision as of 15:03, 6 October 2019

If you want to extract the month of the current date directly, then use CURRENT_TIMESTAMP

SELECT EXTRACT(MONTH FROM CURRENT_TIMESTAMP)