Extensions.DateTime.FormatDate

Classification

Name	FortmatDate
Short Description	Returns a formatted time representation of a timestamp.
Class	Term
Extension	OTX DateTime Extension
Group	-
Exceptions	-
Checker Rules	-
Standard Compliant	Yes

Description

Date format is a term which converts a timestamp in a date format and returns as a string. If there is no formatting specified, is the time to ISO 8601:2004 in the following format:

YYYY-MM-DDThh:mm:ss[.fff]+hh:mm
(The symbols "-", ".", ":", ",", "+" And "T" are delimiters)

The following table gives an overview of the decoding of the individual format icons.

Modules of the ISO 8601 time format

YYYY	MM	DD	hh	mm	ss	fff	hh	mm
Year	Month	Day	Hour	Minute	Second	Milisecond	Hour (difference from GMT)	Minute (difference from GMT)

Pseudo-Code Syntax

time = FormatDate(timeStamp , <<pattern>>);

Properties

Name	Data Type	Class	Default	Cardinality	Description
Time	String	Variable	-	[0..1]	Date in the form according to ISO8601 or as specified.
Timestamp	Integer	Term	-	[0..1]	This property specifies a date as a time stamp, which is interpreted as the number of milliseconds elapsed since January 1 1970 00:00:00 UTC.
Pattern	String	Term	-	[0..1]	This feature can represent time in the desired format.

Examples

2008-02-01T09: 00:22 +05:00 9:00:22 clock on 1 February 2008, in a time zone that is five hours ahead of UTC, for example, in the specified time zone in Pakistan.

2009-01-01T12: 00:00 +01:00 12:00:00 clock on 1 January 2009 in Germany, Liechtenstein, Austria and Switzerland