SET DATE
From Lianjapedia
Revision as of 04:58, 15 April 2021 by Yvonne.milne (Talk | contribs)
Contents
Purpose
Determine input and output date formats
Syntax
SET DATE [TO] AMERICAN | ANSI | BRITISH | DMY | FORMAT <cISOlocale> | FRENCH | GERMAN | ISO | ITALIAN | JAPAN | LOCALE | MDY | USA | YMD
See Also
CTOD(), DATE(), DMY(), DTOC(), DTOS(), DTOV(), LOCALE(), MDY(), SET CENTURY, SET EPOCH, SET MARK, 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 |
FORMAT <cISOlocale> | Specified ISO locale code (from v6.0.2) |
GERMAN | dd.mm.yy |
ITALIAN | dd-mm-yy |
JAPAN or (YMD) | yy/mm/dd |
LOCALE | Current OS locale (from v6.0.2) |
USA | mm-dd-yy |
ISO | yyyy-mm-dd |
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") set date format "en_GB" set date locale