Your Airkit journey starts here
Search

ISO_WEEK

Returns the ISO week number of the year. (1-54)

Declaration

ISO_WEEK(datetime) -> iso week number
ISO_WEEK(date) -> iso week number

Parameters

datetime
datetime -A datetime value to retrieve the week number of the year for.
date
date -A date value to retrieve the week number of the year for.

Return Values

iso week number
number -The ISO week number of the year. (1-54)

← Previous: Reference Tables

Next: Query Expression Syntax →