get day in sql
snippet in sql

get day in sql

user8525

SELECT DATEPART(m, GETDATE()) as theMonth  -- returns 11
SELECT DATEPART(d, GETDATE()) as theDay   -- returns 20
SELECT DATEPART(yy, GETDATE()) as theYear   -- returns 2013

selecting specific day in colum sql

user9389

extract(dow from payment_date)