Difference between revisions of "SET DATE"

From Recital Documentation Wiki
Jump to: navigation, search
(See Also)
 
(6 intermediate revisions by 3 users not shown)
Line 1: Line 1:
=SET DATE=
 
 
 
==Class==
 
Date and Time Data
 
 
  
 
==Purpose==
 
==Purpose==
Line 11: Line 5:
  
 
==Syntax==
 
==Syntax==
SET DATE [TO] AMERICAN | ANSI | BRITISH | DMY | ITALIAN | JAPAN | FRENCH | GERMAN | MDY | USA | YMD
+
SET DATE [TO] AMERICAN | ANSI | BRITISH | DMY | FRENCH | GERMAN | ISO | ITALIAN | JAPAN |  MDY | USA | YMD
 
+
  
 
==See Also==
 
==See Also==
[[SET MARK]], [[SET VAXTIME]], [[CTOD()]], [[DATE()]], [[DMY()]], [[DTOC()]], [[DTOS()]], [[DTOV()]], [[MDY()]], [[STOD()]], [[VTOD()]]
+
[[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.
  
{|
+
 
|Date||Format
+
{| class="wikitable"
 +
!Date||Format
 
|-
 
|-
 
|AMERICAN (or MDY)||mm/dd/yy
 
|AMERICAN (or MDY)||mm/dd/yy
Line 36: Line 30:
 
|-
 
|-
 
|USA||mm-dd-yy
 
|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.
 
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 43: Line 40:
  
 
==Example==
 
==Example==
<pre>
+
<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")</pre>
+
seek ctod("01.01.1998")
 +
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Set_Commands|DATE]]
 
[[Category:Set_Commands|DATE]]
 +
[[Category:Date and Time Data]]
 +
[[Category:Date and Time Data Set Commands]]

Latest revision as of 10:58, 12 November 2009

Purpose

Determine input and output date formats


Syntax

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


Products

Recital, Recital Server