Here’s SQL extract function. 

SELECT

EXTRACT (DAY FROM CURRENT_DATE);

The result will be a number.

Valid elements are SECOND, MINUTE, HOUR,DAY, MONTH and YEAR.

Related Posts