How to Get the Day from a Date in T-SQL (2023)


You’d like to get the day from a date field in a SQL Server database.


Our database has a table named MedicalVisit with data in the columns Id, FirstName, LastName, and VisitDate.


For each patient, let’s find the day of the medical visit. We’ll get it from the VisitDate field.


We’ll use the DAY() function. Here’s the query you would write:

SELECT First_name, Last_name, DAY(VisitDate) AS VisitDayFROM MedicalVisit;

Here’s the result of the query:



If you want to get a day from a date in a table, use the SQL Server DAY() function. This function takes only one argument – the date. This can be a date or date and time data type. (In our example, the column VisitDate is of the date data type.) The argument can be a column name or an expression. (In our example, it is the VisitDate column.)

DAY() returns the number of the day of the month as an integer from 1 to 31. For Alice Thomas’ visit, the day is 5; we get it from the YYYY-MM-DD date ‘2019-11-05’.

Top Articles
Latest Posts
Article information

Author: Kimberely Baumbach CPA

Last Updated: 27/12/2023

Views: 6161

Rating: 4 / 5 (61 voted)

Reviews: 84% of readers found this page helpful

Author information

Name: Kimberely Baumbach CPA

Birthday: 1996-01-14

Address: 8381 Boyce Course, Imeldachester, ND 74681

Phone: +3571286597580

Job: Product Banking Analyst

Hobby: Cosplaying, Inline skating, Amateur radio, Baton twirling, Mountaineering, Flying, Archery

Introduction: My name is Kimberely Baumbach CPA, I am a gorgeous, bright, charming, encouraging, zealous, lively, good person who loves writing and wants to share my knowledge and understanding with you.