T-SQL – How to output day number from date

The following T-SQL statement shows how output the day from a date.

For example, 16 March 2019 would output 16.

SELECT DateName( day, GETDATE() ) as Day_From_Date