This function returns the full timestamp (date and time) of any given date in text form.

Syntax
dateTimeToString(timestamp, timeZone, language) #Output: Text
Examples
Parser ExpressionDescription
%{dateTimeToString({issue.created}, RUN_AS_LOCAL, RUN_AS_LANG)}

This example could return:

18/May/20, 7:52 am

Additional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

NUMBER

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).
timeZone

TIMEZONE

The time zone used for the conversion.

language

LANGUAGE

The language used for the conversion.

Output

This function returns a TEXT

Variant where you can additionally define a custom date time pattern (see documentation).

Syntax
 dateTimeToString(timestamp, dateTimePattern, language) #Output: Text
Examples
Parser expressionDescription
%{dateTimeToString({issue.created}, "YYYY.MM.DD [at] HH:mm:ss", "en_GB")}

This example could return:

2020.05.18 at 07:52:02

Additional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

NUMBER

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).
dateTimePattern

TEXT

A date time pattern in text form according to the moment patterns.

language

LANGUAGE

The language used for the conversion.

Output

This function returns a TEXT

Variant where you can specify a custom format according to the date time pattern (see documentation) and additionally a time zone.

Syntax
 dateTimeToString(timestamp, dateTimePattern, timeZone, language) #Output: Text
Examples
Parser expressionDescription
%{dateTimeToString({issue.created}, "dddd, MMMM Do YYYY, h:mm:ss a", "MST", "en")}

This example will return:

The issue's creation date in a readable way using the Moutain Time Zone e.g. Friday, March 6th 2020, 2:29:21 am

%{dateTimeToString(0, "dddd, MMMM Do YYYY, h:mm:ss a", "Pacific/Auckland", RUN_AS_LANG)}

This example will return:

Thursday, January 1st 1970, 12:00:00 pm


Additional information

Parameters used in this function

ParameterInput (data type)Description
timestamp

NUMBER

The parameter must be a valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).
dateTimePattern

TEXT

A date time pattern in text form according to the moment patterns.
timeZone

TEXT

The time zone used for the conversion.

language

TEXT

The language used for the conversion.

Output

This function returns a TEXT

This function is useful in the Update fields post function to represent as a text the result of a time expression.