Difference between revisions of "SET EPOCH"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
Date and Time Data | Date and Time Data | ||
| Line 15: | Line 12: | ||
==See Also== | ==See Also== | ||
| − | [[ | + | [[CTOD()]], [[DATE()]], [[DTOC()]], [[SET CENTURY]], [[SET DATE]] |
| Line 22: | Line 19: | ||
10/10/97 = October 10th 1997 | 10/10/97 = October 10th 1997 | ||
| + | |||
10/10/27 = October 10th 2027 | 10/10/27 = October 10th 2027 | ||
==Example== | ==Example== | ||
| − | < | + | <code lang="recital"> |
set century off | set century off | ||
| − | set epoch to 1995</ | + | set epoch to 1995</code> |
Revision as of 15:42, 15 April 2009
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
CTOD(), DATE(), DTOC(), SET CENTURY, SET DATE
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
