Difference between revisions of "SET CENTURY"

From Lianjapedia
Jump to: navigation, search
m (Text replace - "Recital" to "Lianja")
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
 
==Purpose==
 
==Purpose==
 
Enable century in dates
 
Enable century in dates
 
  
 
==Syntax==
 
==Syntax==
 
SET CENTURY ON | OFF | (<expL>)
 
SET CENTURY ON | OFF | (<expL>)
 
  
 
==See Also==
 
==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()]]
 
[[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==
 
==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.
 
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==
 
==Example==
Line 21: Line 17:
 
list all for date = ctod("01/01/2003")</code>
 
list all for date = ctod("01/01/2003")</code>
  
 
==Products==
 
Lianja Server, Lianja
 
 
[[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 10:14, 4 February 2013

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")