Advantage Database Server

DAYOFYEAR()

Advantage Concepts

DAYOFYEAR()

Advantage Concepts

This is the first topic This is the last topic  

DAYOFYEAR()

Advantage Concepts

This is the first topic This is the last topic  

Advantage Expression Engine function that returns the day of year of a date value

 

Syntax

DAYOFYEAR( <dDate> ) -> nDay

 

Parameters

<dDate>  A date value to convert.

 

Return Values

DAYOFYEAR() returns a number in the range of 1 to 366 as an integer numeric value.  If the date argument is empty, DAYOFYEAR() returns zero.

 

Remarks

DAYOFYEAR() is a date conversion function used to convert a date value to the day of year.

 

Advantage Expression Engine functions can be used in expressions such as record filter expressions and index expressions. They are not necessarily scalars supported within SQL statements. For a list of supported SQL scalar functions, see Supported Scalar Functions.

 

See Also

DAYOFWEEK()

YEAR()

MONTH()

DAY()

QUARTER()