Page tree
Skip to end of metadata
Go to start of metadata

Syntax

YEAR(<date>)

Description

Returns the year corresponding to a date. The year is returned as an integer, ranging from 1900-9999.

Examples

Current Date and Time

YEAR returns

Oct 15, 2002 4:34:34 AM

2002

Sep 26, 2010 12:33:25 PM

2010

Aug 31, 2011 11:30:45 AM

2011

 

Note that Datameer always uses the following format (e.g. 12.01.2012 gets transferred to January 12, 2012 12:00:00 AM)

When selecting a pattern, you select the way the data gets parsed (your input format, this can be connected to your systems representation of Dates and Times).

  • None