Quick Ref.

SELECT
GROUP BY

Compatibility
DAY(d)
Engine	OK	Alternative
ingres	no	EXTRACT(DAY FROM d)
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: