toIso8601DateTime

warning

toIso8601DateTime is deprecated. Use formatTimestamp instead.

Description

Returns a timestamp formatted as an ISO 8601 string (e.g. 2023-08-11T07:29:17.634Z). This function supports nanosecond precision.

Syntax

Like many functions in DataPrime, toIso8601DateTime supports two notations, function and method. These interchangeable forms allow flexibility in how you structure expressions.

Function notation

toIso8601DateTime(timestamp: timestamp): string

Method notation

(timestamp: timestamp).toIso8601DateTime(): string

Arguments

Name	Type	Required	Description
timestamp	timestamp	true	The timestamp to format in ISO 8601

Example

Use case: Convert a timestamp into ISO 8601 format

Example query

Function notation

create formatted_ts from toIso8601DateTime($m.timestamp)

Method notation

create formatted_ts from $m.timestamp.toIso8601DateTime()

Example output

{
  "formatted_ts": "2023-08-11T07:29:17.634Z"
}