MONTHWEEK_CLAIM scalar function

Returns the week of the month that ADATE exists within, according to the CLAIM calendar.

Prototypes

MONTHWEEK_CLAIM(ADATE DATE)
MONTHWEEK_CLAIM(ADATE TIMESTAMP)
MONTHWEEK_CLAIM(ADATE VARCHAR(26))

RETURNS SMALLINT

Description

Returns the week of the month of ADATE, according to the CLAIM calendar. ADATE can be expressed as a DATE value, a TIMESTAMP, or a VARCHAR containing a valid string representation of a date or timestamp. If ADATE is NULL, the result is NULL. Otherwise, the result is a SMALLINT between 1 and 5.

Parameters

ADATE

The date to calculate the week of the month for, according to the CLAIM calendar.

Examples

Calculate the week of CLAIM month for the 1st of June, 2010:

VALUES MONTHWEEK_CLAIM(DATE(2010, 6, 1));

1
------
     1

Calculate the week of CLAIM month for the 31st of January, 2010:

VALUES MONTHWEEK_CLAIM('2010-01-31');

1
------
     2

See Also

• Source code
• DAY_CLAIM
• WEEK_CLAIM scalar function
• MONTH_CLAIM scalar function
• YEAR_CLAIM scalar function