The best way extract day from DATE in SQL

There is an extract function. 

SELECT

EXTRACT (DAY FROM CURRENT_DATE);

The result will be a number.

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

Advertisements

Author: Srini

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