Quick Ref.
Functions
date
number
string
Data Types
date
number
string
Compatibility
DAY(d)
Engine OK Alternative
mysql yes EXTRACT(DAY FROM d)
oracle no TO_CHAR(d,'DD')
postgres no EXTRACT(DAY FROM (d)
sqlserver yes DATEPART(DAY,d)

DAY

DAY allows you to retrieve the day from a date. 

 DAY(d)

In this example you get the day from the date field whn.


Results
See also: