Difference between revisions of "YEAR()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to extract year from date or datetime | Function to extract year from date or datetime | ||
− | |||
==Syntax== | ==Syntax== | ||
YEAR(<expD> | <expT>) | YEAR(<expD> | <expT>) | ||
− | |||
==See Also== | ==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()]] | [[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== | ==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. | 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== | ==Example== | ||
Line 24: | Line 20: | ||
2004 | 2004 | ||
</code> | </code> | ||
− | |||
==Products== | ==Products== |
Revision as of 11:31, 12 December 2012
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
Lianja, Lianja Server