Difference between revisions of "EPOCH()"

Latest revision as of 08:41, 8 October 2019

Purpose

Function to return the current EPOCH setting

Syntax

EPOCH()

See Also

AMPM(), CDOW(), CMONTH(), CTOD(), CTOT(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOA(), DTOC(), DTOM(), DTOS(), DTOT(), DTOV(), ELAPTIME(), EMPTY(), GOMONTH(), HOUR(), HOURS(), ISLEAPYEAR(), LEAPYEARS(), LTOS(), MDY(), MINUTE(), MINUTES(), MONTH(), MTOD(), MTOS(), QUARTER(), SEC(), SECONDS(), SECS(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, SET SECONDS, STOD(), STOT(), STR(), STRFTIME(), TIME(), TIMEOFDAY(), TIMESTAMP(), TSTRING(), TTOC(), TTOD(), TYPE(), VAL(), VALIDTIME(), VTOD(), WEEK(), YEAR()

Description

The EPOCH() function returns the current SET EPOCH setting as a numeric 4 digit year. The SET EPOCH TO <expN> command allows for the specification of the starting year of a one hundred-year period. The one hundred-year period can span two consecutive centuries. Two-digit year dates (SET CENTURY OFF) can be used and still assigned the correct century provided that they fall within this one-hundred year period. For example, SET EPOCH TO 1995 would specify a one hundred-year period from 1995 to 2094. Any two-digit years less than 95 would be 21st century, any two-digit years of 95 or over would be 20th century.

10/10/97 = October 10th 1997

10/10/27 = October 10th 2027

By default, EPOCH is set to 1900.

Example

? epoch()
      1900
set epoch to 1995
? epoch()
      1995