BALA SINGAM

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.