Difference between revisions of "SET CENTURY"

From Recital Documentation Wiki
Jump to: navigation, search
Line 31: Line 31:
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Set_Commands|CENTURY]]
 
[[Category:Set_Commands|CENTURY]]
 +
[[Category:Date and Time Data]]
 +
[[Category:Date and Time Data Set Commands]]

Revision as of 10:30, 2 June 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