Bala Singam

Disclaimer : This tutorial is meant for beginners and for anyone who find it useful. The main purpose of this post to keep everything i find useful for future reference for myself and for others.

This small tutorial is to show how to get particular date part of from a date value field in SQL Server query.

select sales_date,
Day(sales_date) as Day,
Month(sales_date) as Month,
Year(sales_date) as Year,
Day(getDate()) as Current_Day,
Month(getDate()) as Current_Month,
Year(getDate()) as Current_Year
from sales_detail

Result

In above query my date field is sales_date , using Day , Month and Year function i can get the particular date part by passing sales_date as parameter. This is to get date part value from a particular field value.

To get date part from current date is almost same only passing the current date as parameter. To get current date use getDate() function which will return the current date.