SET DATE

Purpose

Determine input and output date formats

Syntax

SET DATE [TO] AMERICAN | ANSI | BRITISH | DMY | FORMAT <cISOlocale> | FRENCH | GERMAN | ISO | ITALIAN | JAPAN | LOCALE | LONG | MDY | SHORT | USA | YMD

See Also

CTOD(), DATE(), DMY(), DTOC(), DTOS(), DTOV(), LOCALE(), MDY(), SET CENTURY, SET DATEFORMAT, 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
ISO	yyyy-mm-dd
ITALIAN	dd-mm-yy
JAPAN or (YMD)	yy/mm/dd
LOCALE	Current OS locale (from v6.0.2)
LONG	Long date format (from v9.2.6)
SHORT	Short date format (from v9.2.6)
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")
set date format "en_GB"
set date locale