Difference between revisions of "SET DATE"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) (→Syntax) |
Yvonnemilne (Talk | contribs) |
||
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
==Class== | ==Class== | ||
Date and Time Data | Date and Time Data | ||
Line 14: | Line 11: | ||
==See Also== | ==See Also== | ||
− | + | [[CTOD()]], [[DATE()]], [[DMY()]], [[DTOC()]], [[DTOS()]], [[DTOV()]], [[MDY()]], [[SET CENTURY]], [[SET EPOCH]], [[SET MARK]], [[SET VAXTIME]], [[STOD()]], [[VTOD()]] | |
==Description== | ==Description== | ||
The SET DATE command specifies the input and output format for dates. The following summarizes the available date formats. | The SET DATE command specifies the input and output format for dates. The following summarizes the available date formats. | ||
− | {| | + | |
+ | {| class="wikitable" | ||
|Date||Format | |Date||Format | ||
|- | |- | ||
Line 37: | Line 35: | ||
|- | |- | ||
|} | |} | ||
+ | |||
If SET CENTURY is ON, then the years will be formatted with four digits, i.e. yyyy. The SET MARK command may be used to specify an alternate character to separate the parts of a date. | If SET CENTURY is ON, then the years will be formatted with four digits, i.e. yyyy. The SET MARK command may be used to specify an alternate character to separate the parts of a date. | ||
Line 42: | Line 41: | ||
==Example== | ==Example== | ||
− | < | + | <code lang="recital"> |
set date german | set date german | ||
use patrons index dates | use patrons index dates | ||
seek ctod("01.01.98") | seek ctod("01.01.98") | ||
set century on | set century on | ||
− | seek ctod("01.01.1998")</ | + | seek ctod("01.01.1998")</code> |
Revision as of 14:18, 15 April 2009
Class
Date and Time Data
Purpose
Determine input and output date formats
Syntax
SET DATE [TO] AMERICAN | ANSI | BRITISH | DMY | FRENCH | GERMAN | ITALIAN | JAPAN | MDY | USA | YMD
See Also
CTOD(), DATE(), DMY(), DTOC(), DTOS(), DTOV(), MDY(), SET CENTURY, SET EPOCH, SET MARK, SET VAXTIME, STOD(), VTOD()
Description
The SET DATE command specifies the input and output format for dates. The following summarizes the available date formats.
Date | Format |
AMERICAN (or MDY) | mm/dd/yy |
ANSI | yy.mm.dd |
BRITISH or FRENCH or (DMY) | dd/mm/yy |
GERMAN | dd.mm.yy |
ITALIAN | dd-mm-yy |
JAPAN or (YMD) | yy/mm/dd |
USA | mm-dd-yy |
If SET CENTURY is ON, then the years will be formatted with four digits, i.e. yyyy. The SET MARK command may be used to specify an alternate character to separate the parts of a date.
Example
set date german use patrons index dates seek ctod("01.01.98") set century on seek ctod("01.01.1998")
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer