1. Home
  2. Knowledge Base
  3. SQL Server
  4. T-SQL – How to output day number from date

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

Was this article helpful?

Related Articles