Difference between revisions of "SET EPOCH"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
Line 34: | Line 34: | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|EPOCH]] | [[Category:Set_Commands|EPOCH]] | ||
+ | [[Category:Date and Time Data]] | ||
+ | [[Category:Date and Time Data Set Commands]] |
Revision as of 10:31, 2 June 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