toDateTime

Last update: 2023-01-23
  • Created for:
  • Experienced
    Developer

Converts parameters into a date time value, depending on their types.

Category

Conversion

Function syntax

toDateTime(<parameters>)

Parameters

Parameter Type
date time in ISO-8601 format string
time zone id string
date time without time zone dateTimeOnly
integer value of an epoch in milliseconds integer
NOTE

Time zone id must be a string constant. It cannot be a field reference nor an expression. For more information on data types, refer to this page.

Signatures and returned types

toDateTime(<string>)

toDateTime(<stringified time zone id>, <dateTimeOnly>)

toDateTime(<integer>)

Return a dateTime.

Examples

toDateTime ("2016-08-18T23:17:59.123Z")

Returns 2016-08-18T23:17:59.123Z

toDateTime(toDateTimeOnly("UTC", "2016-08-18T23:17:59.123"))

Returns 2016-08-18T23:17:59.123Z

toDateTime(1560762190189)

Returns 2019-06-17T09:03:10.189Z

On this page