Advantage Database Server

ISOWEEK()

Advantage Concepts

ISOWEEK()

Advantage Concepts

This is the first topic This is the last topic  

ISOWEEK()

Advantage Concepts

This is the first topic This is the last topic  

Advantage Expression Engine function that returns the ISO 8601 week number of a date value

 

Syntax

ISOWEEK( <dDate> ) -> nISOWeek

 

Parameters

<dDate>  A date value to convert.

 

Return Values

ISOWEEK() returns a number in the range of 1 to 53 as an integer numeric value.  If the time or timestamp argument is empty, ISOWEEK() returns zero.

 

Remarks

ISOWEEK() is a date conversion function used to return the ISO 8601 week number of a date value.

 

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

WEEK()

YEAR()

MONTH()

DAY()

QUARTER()