WEEKSINYEAR scalar function

Returns the number of weeks within the year that ADATE exists within, or the number of weeks in AYEAR.

Prototypes

WEEKSINYEAR(AYEAR INTEGER)
WEEKSINYEAR(ADATE DATE)
WEEKSINYEAR(ADATE TIMESTAMP)
WEEKSINYEAR(ADATE VARCHAR(26))

RETURNS SMALLINT

Description

Returns the number of weeks in AYEAR (weeks start on a Sunday, and partial weeks are permitted at the start and end of the year), or the number of weeks in the year that ADATE exists within depending on the variant of the function that is called.

Parameters

AYEAR
If provided, the year for which to calculate the number of weeks.
ADATE
If provided, the date in the year for which to calculate the number of weeks. Either AYEAR or ADATE must be specified.

Examples

Calculate the number of weeks in the year 2010:

VALUES WEEKSINYEAR(2010);

1
------
    53

Calculate the number of weeks in the first 10 years of the 21st century:

SELECT YEAR(D) AS YEAR, WEEKSINYEAR(D) AS WEEKS
FROM TABLE(DATE_RANGE('2000-01-01', '2010-01-01', 10000));

YEAR        WEEKS
----------- ------
       2000     54
       2001     53
       2002     53
       2003     53
       2004     53
       2005     53
       2006     53
       2007     53
       2008     53
       2009     53
       2010     53

See Also