SET EPOCH

From Recital Documentation Wiki
Revision as of 16:13, 10 March 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

SET EPOCH

Class

Date and Time Data


Purpose

Specify a one hundred-year epoch to allow for two digit years.


Syntax

SET EPOCH TO <expN>


See Also

SET CENTURY, SET DATE, DATE(), CTOD(), DTOC()


Description

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


Example

set century off
set epoch to 1995


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer