Difference between revisions of "SET DATE"

From Lianjapedia
Jump to: navigation, search
Line 3: Line 3:
  
 
==Syntax==
 
==Syntax==
SET DATE [TO] AMERICAN | ANSI | BRITISH | DMY | FRENCH | GERMAN | ISO | ITALIAN | JAPAN |  MDY | USA | YMD
+
SET DATE [TO] AMERICAN | ANSI | BRITISH | DMY | FRENCH | GERMAN | ISO | ITALIAN | JAPAN |  LOCALE | MDY | USA | YMD
  
 
==See Also==
 
==See Also==
[[CTOD()]], [[DATE()]], [[DMY()]], [[DTOC()]], [[DTOS()]], [[DTOV()]], [[MDY()]], [[SET CENTURY]], [[SET EPOCH]], [[SET MARK]], [[STOD()]], [[VTOD()]]
+
[[CTOD()]], [[DATE()]], [[DMY()]], [[DTOC()]], [[DTOS()]], [[DTOV()]], [[LOCALE()]], [[MDY()]], [[SET CENTURY]], [[SET EPOCH]], [[SET MARK]], [[STOD()]], [[VTOD()]]
  
 
==Description==
 
==Description==
Line 25: Line 25:
 
|-
 
|-
 
|JAPAN or (YMD)||yy/mm/dd
 
|JAPAN or (YMD)||yy/mm/dd
 +
|-
 +
|LOCALE||Current OS locale (from v6.0.2)
 
|-
 
|-
 
|USA||mm-dd-yy
 
|USA||mm-dd-yy

Revision as of 04:48, 15 April 2021

Purpose

Determine input and output date formats

Syntax

SET DATE [TO] AMERICAN | ANSI | BRITISH | DMY | 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
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")