SET DATE
From Recital Documentation Wiki
Revision as of 16:28, 10 March 2009 by Yvonnemilne (Talk | contribs)
Contents
SET DATE
Class
Date and Time Data
Purpose
Determine input and output date formats
Syntax
SET DATE [TO] AMERICAN | ANSI | BRITISH | DMY | ITALIAN | JAPAN | FRENCH | GERMAN | MDY | USA | YMD
See Also
SET MARK, SET VAXTIME, DATE(), CTOD(), DTOC(), DTOS(), STOD(), DTOV(), VTOD(), DMY(), MDY()
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
