Difference between revisions of "SET CENTURY"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 15: | Line 15: | ||
==See Also== | ==See Also== | ||
| − | CDOW(), CMONTH(), CTOD(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOC(), DTOM(), DTOS(), DTOV(), EPOCH(), GOMONTH(), MDY(), MONTH(), MTOD(), QUARTER(), STOD(), VTOD(), YEAR(), SET DATE, SET EPOCH, SET MARK, SET SECONDS | + | [[CDOW()]], [[CMONTH()]], [[CTOD()]], [[DATE()]], [[DATETIME()]], [[DAY()]], [[DAYS()]], [[DMY()]], [[DOW()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOV()]], [[EPOCH()]], [[GOMONTH()]], [[MDY()]], [[MONTH()]], [[MTOD()]], [[QUARTER()]], [[STOD()]], [[VTOD()]], [[YEAR()]], [[SET DATE]], [[SET EPOCH]], [[SET MARK]], [[SET SECONDS]] |
| Line 33: | Line 33: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| − | [[Category:Set_Commands]] | + | [[Category:Set_Commands|CENTURY]] |
Revision as of 12:07, 11 March 2009
Contents
SET CENTURY
Class
Date and Time Data
Purpose
Enable century in dates
Syntax
SET CENTURY ON | OFF | (<expL>)
See Also
CDOW(), CMONTH(), CTOD(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOC(), DTOM(), DTOS(), DTOV(), EPOCH(), GOMONTH(), MDY(), MONTH(), MTOD(), QUARTER(), STOD(), VTOD(), YEAR(), SET DATE, SET EPOCH, SET MARK, SET SECONDS
Description
If SET CENTURY is ON, then dates are displayed, and can be input with the century prefix specified. If CENTURY is OFF then the year part of dates is only two digits, and the 20th century is assumed. By default, CENTURY is ON.
Example
set century on
use patrons index dates
list all for date = ctod("01/01/2003")
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
