Difference between revisions of "YEAR()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (One intermediate revision by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to extract year from date or datetime | Function to extract year from date or datetime | ||
| Line 31: | Line 27: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[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]] | ||
Latest revision as of 17:00, 8 December 2009
Purpose
Function to extract year from date or datetime
Syntax
YEAR(<expD> | <expT>)
See Also
CDOW(), CMONTH(), CTOD(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOC(), DTOM(), DTOS(), DTOV(), EPOCH(), GOMONTH(), MDY(), MONTH(), MTOD(), QUARTER(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, STOD(), VTOD()
Description
The YEAR() function returns the numeric year value from a date expression, <expD> or a datetime expression <expT>. If SET CENTURY is ON (default), the century will be displayed with normal date displays.
Example
? date() 04/04/2004 ? year(date()) 2004 ? year(datetime()) 2004
Products
Recital, Recital Server
