You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 32 Next »

Returns the full timestamp of any given date in text form

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

This example will take the timestamp (date-time in milliseconds) and translates it to a user friendly text, displayed in the entered language's format.

This example will 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

The function returns a TEXT.

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


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

Syntax
 dateTimeToString(timestamp, dateTimePattern, language) #Output: Text
Example
Parser expressionDescription
dateTimeToString({issue.created}, "yyyy.MM.dd 'at' HH:mm:ss", USER_LANG)

This example takes the issue's creation date (in milliseconds) and converts it to a text by using the given date time pattern.

This example will 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 Java Date time pattern (see documentation).

language

LANGUAGE

The language used for the conversion. 

Output

The function returns a TEXT.

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


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

Syntax
 dateTimeToString(timestamp, dateTimePattern, timeZone, language) #Output: Text
Examples
Parser expressionDescription
dateTimeToString(0, "yyyy.MM.dd 'at' HH:mm:ss", GMT, USER_LANG)

This example will return: "1970.01.01 at 00:00:00"

dateTimeToString(0, "yyyy.MM.dd 'at' HH:mm:ss", MST, USER_LANG)

This example will return: "1969.12.31 at 17:00:00"

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

NUMBER

A date time pattern in text form according to the Java Date time pattern (see documentation).
timeZone

TIMEZONE

The time zone used for the calculation. 

language

LANGUAGE

The language used for the conversion. 

Output

The function returns a TEXT.

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