> ## 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: ISODatetimeToTimestampFormat

> Convert an ISO 8601 datetime string to JDBC timestamp format (yyyy-MM-dd HH:mm:ss). Use for database compatibility in ETL pipeline expressions.

## Description

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

## Syntax

`ISODatetimeToTimestampFormat(datetime_string)`

## Examples

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

## Return value datatype

string

## Notes

Returns null if datetime\_string is not a valid ISO datetime. Output is always in UTC (i.e. '1994-11-05T08:15:30-05:00' is converted to '1994-11-05 13:15:30.0').

## Impact of null value

If ISODatetimeString parameter is null, returns null.