EXTRACTDAY

This function returns the day component of the input timestamp value. Also see EXTRACT.

Syntax

EXTRACT(DAY FROM TIMESTAMP timestamp_expr)