> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ETL: TimestampFormatToISODatetime

> Convert a JDBC timestamp format string (yyyy-MM-dd HH:mm:ss) to ISO 8601 format. Use for date standardization in Integrate.io ETL pipelines.

## Description

Convert datetime string in JDBC timestamp string format to ISO 8601 format.

## Syntax

`TimestampFormatToISODatetime(string_expression)`

## Examples

` TimestampFormatToISODatetime('2013-10-17 23:59:54.432')` returns 2013-10-17T23:59:54.432Z

## Return value datatype

string

## Notes

Returns null if TimestampString is not a valid JDBC timestamp (yyyy-MM-dd HH:mm:ss\[.fffffffff]). The output ISO datetime is always in UTC timezone.

## Impact of null value

If TimestampString parameter is null, returns null.