EXTRACTDOY

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

Syntax

EXTRACT(DOY FROM TIMESTAMP timestamp_expr)