get day from datetime in sql code example
Example 1: get day in sql
SELECT DATEPART(m, GETDATE()) as theMonth -- returns 11
SELECT DATEPART(d, GETDATE()) as theDay -- returns 20
SELECT DATEPART(yy, GETDATE()) as theYear -- returns 2013
Example 2: selecting specific day in colum sql
extract(dow from payment_date)