SQL – How to Extract Day from DATE

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

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.