dateTimeToString()

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

Syntax

dateTimeToString(timestamp, timeZone, language) #Output: Text

Parser Expression

Description

dateTimeToString({issue.created}, LOCAL, USER_LANG)

This example could return:

18/May/20 7:52 AM

Additional information

Parameters used in this function

Parameter	Input (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.

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

Parser expression	Description
dateTimeToString({issue.created}, "yyyy.MM.dd 'at' HH:mm:ss", USER_LANG)	This example could return: 2020.05.18 at 07:52:02

Parameters used in this function

Parameter	Input (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 Java date time pattern (see documentation).
`language`	LANGUAGE	The language used for the conversion.

This function returns a TEXT

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

Parser expression	Description
dateTimeToString(0, "yyyy.MM.dd 'at' HH:mm:ss", GMT, USER_LANG)	This example returns: 1970.01.01 at 00:00:00
dateTimeToString(0, "yyyy.MM.dd 'at' HH:mm:ss", MST, USER_LANG)	This example returns: 1969.12.31 at 17:00:00

Parameters used in this function

Parameter	Input (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 Java date time pattern (see documentation).
`timeZone`	TIMEZONE	The time zone used for the calculation.
`language`	LANGUAGE	The language used for the conversion.