...
Parameter | Type | Description |
---|---|---|
Text | Text/Each | The text value to convert. |
Locale (Optional) | Text | Optional locale identifier, such as "fr_FR". If not specified, user's locale is used. |
TimeZone (Optional) | Text | Optional time zone identifier, such as "America/New_York". |
→ Result | Number | Timestamp, corresponding to midnight of the specified date at the specified time zone. If conversion is unsuccessful, returns an error. |
The conversion uses the standard formats for representing dates:
- Format "yyyy-MM-dd", like "2017-04-15".
Standard formats for the specified locale.
Jira formats, as specified in the Jira's system settings.
...
FORMAT_DATETIME(DateTime, Format
, Locale
,
...
TimeZone)
Advanced function to convert a date/time value into a text. Accepts an arbitrary format text and, optionally, locale and time zone settings. Does not depend on the current user's locale nor time zone.
Parameter | Type | Description |
---|---|---|
DateTime | Date/Each | The value to convert. |
Format | Text | The format string. For all the options, please see Java documentation for SimpleDateFormat. |
Locale (Optional) | Text | Optional locale identifier. If omitted or undefined , will use Jira's system locale. (Not the user's locale!) |
TimeZone (Optional) | Text | Optional time zone identifier. If omitted or undefined , will use Jira's system time zone. (Not the user's time zone!) |
→ Result | Text | DateTime converted to text. |
Examples:
FORMAT_DATETIME(DATE("2017-04-15"), "EEE, MMM d, `yy", "fr_FR") → "sam., avr. 15, `17"
FORMAT_DATETIME(DATETIME("2016-12-31 23:59"), "yyyy-MM-dd'T'HH:mm:ss") → "2016-12-31T23:59:00"
...