Difference between revisions of "SET CENTURY"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Enable century in dates | Enable century in dates | ||
| Line 15: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[CDOW()]], [[CMONTH()]], [[CTOD()]], [[DATE()]], [[DATETIME()]], [[DAY()]], [[DAYS()]], [[DMY()]], [[DOW()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOV()]], [[EPOCH()]], [[GOMONTH()]], [[MDY()]], [[MONTH()]], [[MTOD()]], [[QUARTER()]], [[ | + | [[CDOW()]], [[CMONTH()]], [[CTOD()]], [[DATE()]], [[DATETIME()]], [[DAY()]], [[DAYS()]], [[DMY()]], [[DOW()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOV()]], [[EPOCH()]], [[GOMONTH()]], [[MDY()]], [[MONTH()]], [[MTOD()]], [[QUARTER()]], [[SET DATE]], [[SET EPOCH]], [[SET MARK]], [[SET SECONDS]], [[STOD()]], [[VTOD()]], [[YEAR()]] |
| Line 23: | Line 16: | ||
==Example== | ==Example== | ||
| − | < | + | <code lang="recital"> |
set century on | set century on | ||
use patrons index dates | use patrons index dates | ||
| − | list all for date = ctod("01/01/2003")</ | + | list all for date = ctod("01/01/2003")</code> |
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|CENTURY]] | [[Category:Set_Commands|CENTURY]] | ||
| + | [[Category:Date and Time Data]] | ||
| + | [[Category:Date and Time Data Set Commands]] | ||
Latest revision as of 16:46, 12 November 2009
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(), SET DATE, SET EPOCH, SET MARK, SET SECONDS, STOD(), VTOD(), YEAR()
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 Server, Recital
