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

0 vote179 views2 answers
How to display enum value sql server
SQL
0 vote163 views1 answer
How to install Firebird
SQL
2 votes176 views1 answer
Oracle run_duration average
SQL
44 votes186 views6 answers
Rename command in sql
SQL
0 vote195 views1 answer
How to set up an anonymous function to variable in swift
SQL
0 vote167 views1 answer
Download mysql database to excel in android studio
SQL
1 vote181 views1 answer
Postgresql float 2 decimal places
SQL
0 vote166 views1 answer
Addition of 2 column value in mysql
SQL
0 vote184 views1 answer
Sql server change schema of a table
SQL
0 vote208 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL