YEAR()
From Lianjapedia
Revision as of 11:31, 12 December 2012 by Helen.george (Talk | contribs)
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