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

Fediverse reactions

Discover more from Srinimf

Subscribe now to keep reading and get access to the full archive.

Continue reading