Difference between revisions of "SET CENTURY"
From Recital Documentation Wiki
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== | ||
| − | [[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 20: | ||
==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> |
Revision as of 12:21, 15 April 2009
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(), 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 Database Server, Recital Mirage Server, Recital Terminal Developer
