Difference between revisions of "SET EPOCH"

From Recital Documentation Wiki
Jump to: navigation, search
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET EPOCH=
 
 
 
==Class==
 
Date and Time Data
 
 
 
 
==Purpose==
 
==Purpose==
 
Specify a one hundred-year epoch to allow for two digit years.
 
Specify a one hundred-year epoch to allow for two digit years.
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
[[SET CENTURY]], [[SET DATE]], [[DATE()]], [[CTOD()]], [[DTOC()]]
+
[[CTOD()]], [[DATE()]], [[DTOC()]], [[SET CENTURY]], [[SET DATE]]
  
  
Line 22: Line 15:
  
 
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==
<pre>
+
<code lang="recital">
 
set century off
 
set century off
set epoch to 1995</pre>
+
set epoch to 1995</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Set_Commands|EPOCH]]
 
[[Category:Set_Commands|EPOCH]]
 +
[[Category:Date and Time Data]]
 +
[[Category:Date and Time Data Set Commands]]

Latest revision as of 15:45, 23 November 2009

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 Server, Recital