YEAR_CLAIM scalar function¶
Returns the year that ADATE exists within, according to the CLAIM calendar.
Prototypes¶
YEAR_CLAIM(ADATE DATE)
YEAR_CLAIM(ADATE TIMESTAMP)
YEAR_CLAIM(ADATE VARCHAR(26))
RETURNS SMALLINT
Description¶
Returns the year 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.
Parameters¶
- ADATE
- The date to calculate the year of, according to the CLAIM calendar.
Examples¶
Calculate the CLAIM year for the 31st of December, 2010:
VALUES YEAR_CLAIM(DATE(2010, 12, 31));
1
------
2011
Calculate the length of all CLAIM years in the decade starting 2000:
SELECT YEAR_CLAIM(D) AS YEAR, COUNT(*) AS DAYS
FROM TABLE(DATE_RANGE(YEARSTART_CLAIM(2000), YEAREND_CLAIM(2010)))
GROUP BY YEAR_CLAIM(D);
YEAR DAYS
------ -----------
2000 364
2001 364
2002 364
2003 371
2004 364
2005 364
2006 364
2007 364
2008 371
2009 364
2010 364
See Also¶
- Source code
- YEAR (built-in function)
- DAY_CLAIM
- WEEK_CLAIM scalar function
- MONTH_CLAIM scalar function
- QUARTER_CLAIM scalar function