Reference Guide
>
TDV Support for SQL Functions
>
Date Functions
>
EXTRACTDOY
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)