SQL - Extract month from current date

Revision as of 15:03, 6 October 2019 by Ardaut (talk | changes) (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")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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

SELECT EXTRACT(MONTH FROM CURRENT_TIMESTAMP)