Difference between revisions of "LEAPYEARS()"
Yvonne.milne (Talk | contribs) m (1 revision) |
|||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return number of leap years between 01/01/0001 and the specified date | Function to return number of leap years between 01/01/0001 and the specified date | ||
| − | |||
==Syntax== | ==Syntax== | ||
LEAPYEARS(<expD> | <expT> | <expN>) | LEAPYEARS(<expD> | <expT> | <expN>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[AMPM()]], [[CDOW()]], [[CMONTH()]], [[CTOD()]], [[CTOT()]], [[DATE()]], [[DATETIME()]], [[DAYS()]], [[DMY()]], [[DOW()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOV()]], [[ELAPTIME()]], [[EPOCH()]], [[GOMONTH()]], [[HOUR()]], [[HOURS()]], [[ISLEAPYEAR()]], [[MDY()]], [[MINUTE()]], [[MINUTES()]], [[MONTH()]], [[MTOD()]], [[QUARTER()]], [[SEC()]], [[SECONDS()]], [[SECS()]], [[SET CENTURY]], [[SET DATE]], [[SET EPOCH]], [[SET HOURS]], [[SET MARK]], [[SET SECONDS | + | [[AMPM()]], [[CDOW()]], [[CMONTH()]], [[CTOD()]], [[CTOT()]], [[DATE()]], [[DATETIME()]], [[DAYS()]], [[DMY()]], [[DOW()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOV()]], [[ELAPTIME()]], [[EPOCH()]], [[GOMONTH()]], [[HOUR()]], [[HOURS()]], [[ISLEAPYEAR()]], [[MDY()]], [[MINUTE()]], [[MINUTES()]], [[MONTH()]], [[MTOD()]], [[QUARTER()]], [[SEC()]], [[SECONDS()]], [[SECS()]], [[SET CENTURY]], [[SET DATE]], [[SET EPOCH]], [[SET HOURS]], [[SET MARK]], [[SET SECONDS]], [[STOD()]], [[SYS()]], [[TIME()]], [[TIMESTAMP()]], [[TSTRING()]], [[TTOC()]], [[TTOD()]], [[VALIDTIME()]], [[VTOD()]], [[WEEK()]], [[YEAR()]] |
==Description== | ==Description== | ||
The LEAPYEARS() function is used to return number of leap years between 01/01/0001 and the specified date. The date can be specified as a date expression (<expD>), a datetime expression (<expT>) or as a numeric value indicating a Julian date (<expN>). | The LEAPYEARS() function is used to return number of leap years between 01/01/0001 and the specified date. The date can be specified as a date expression (<expD>), a datetime expression (<expT>) or as a numeric value indicating a Julian date (<expN>). | ||
| − | |||
==Example== | ==Example== | ||
| Line 24: | Line 21: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:Date and Time Data]] | [[Category:Date and Time Data]] | ||
[[Category:Date and Time Data Functions]] | [[Category:Date and Time Data Functions]] | ||
Revision as of 08:08, 25 November 2011
Contents
Purpose
Function to return number of leap years between 01/01/0001 and the specified date
Syntax
LEAPYEARS(<expD> | <expT> | <expN>)
See Also
AMPM(), CDOW(), CMONTH(), CTOD(), CTOT(), DATE(), DATETIME(), DAYS(), DMY(), DOW(), DTOC(), DTOM(), DTOS(), DTOV(), ELAPTIME(), EPOCH(), GOMONTH(), HOUR(), HOURS(), ISLEAPYEAR(), MDY(), MINUTE(), MINUTES(), MONTH(), MTOD(), QUARTER(), SEC(), SECONDS(), SECS(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, SET SECONDS, STOD(), SYS(), TIME(), TIMESTAMP(), TSTRING(), TTOC(), TTOD(), VALIDTIME(), VTOD(), WEEK(), YEAR()
Description
The LEAPYEARS() function is used to return number of leap years between 01/01/0001 and the specified date. The date can be specified as a date expression (<expD>), a datetime expression (<expT>) or as a numeric value indicating a Julian date (<expN>).
Example
? leapyears(date()) 487 ? leapyears(datetime()) 487 ? leapyears(val(sys(1))) 487
