Get day in sql

Selecting specific day in colum sql

extract(dow from payment_date)

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

-1

Source: stackoverflow.com

Similar codes

51 votes294 views6 answers
Change column name sql
SQL
0 vote228 views1 answer
Group by max date
SQL
0 vote181 views1 answer
In mysql workbench contnent not feching
SQL
0 vote202 views1 answer
Search from comma separated values in sql server
SQL
0 vote195 views1 answer
Oracle sql generate list of days
SQL
1 vote192 views1 answer
Oracle apex prevent initial load
SQL
3 votes218 views2 answers
Sql not contains
SQL
0 vote192 views1 answer
Get clob size oracle
SQL
7 votes275 views2 answers
Oracle foreign key reference table
SQL
5 votes198 views1 answer
Oracle get foreign keys on table
SQL