4D v16

DAYOFYEAR

Home

 
4D v16
DAYOFYEAR

DAYOFYEAR  


 

 

Command DAYOFYEARDAYOFYEAR (arithmetic_expression)

The DAYOFYEAR function returns a number representing the day of the year (ranging from 1 to 366, where 1 is January 1st) of the date passed in the arithmetic_expression.

Example  

Supposing that we have the PEOPLE table with a Date_of_Birth field. To find out the day of the year of the date of birth for every person in PEOPLE:

SELECT DAYOFYEAR(Date_of_Birth)
FROM PEOPLE;



See also 

DAY
DAYNAME
DAYOFMONTH
DAYOFWEEK

 
PROPERTIES 

Product: 4D
Theme: Functions

 
HISTORY 

 
ARTICLE USAGE

4D SQL Reference ( 4D v16)