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

1 vote213 views1 answer
Oracle extract minute from date
SQL
0 vote172 views1 answer
Implicit inner join table alias with id values
SQL
0 vote156 views2 answers
How to set global time_zone in mysql
SQL
8 votes182 views1 answer
Oracle search text in all packages
SQL
0 vote178 views1 answer
Create sql table from script inline primary key constraint
SQL
5 votes171 views1 answer
Mysql count lines
SQL
0 vote171 views1 answer
Where date major today mysql
SQL
1 vote286 views3 answers
Uninstall postgresql mac
SQL
2 votes163 views1 answer
How to delete view in sql
SQL
19 votes168 views5 answers
Change column name mysql command line
SQL