SQL Server Transact Basic to Expert - Display the date integer value using systemdate

This blog shows the current date integer value from the system date using SQL query

Example:

SELECT DAY(GETDATE())

The expected result would be 16