Parse String to Timestamp

The Parse String to Timestamp action formats a STRING variable into a TIMESTAMP variable in several standard formats, including custom formats.

Parameter description

Parameter Description
Format This is the format in which you want the date and time information to appear. Select a format from the list.

The options are:
  • Y-m-dTH:M:S - Complete date plus hours, minutes and seconds.
    For example: 2008-04-22T19:20:30
    As specified in ISO 8601.
  • Y-m-d - Complete date.
    For example: 2008-04-22
  • Ymd - Complete date.
    For example: 20080422
  • H:M:S - Hour, minute, second.
    For example: 11:36:06
  • Custom - Note to programmers: The custom format uses the C-runtime strftime() function under the covers, so the format string must be a valid format string for strftime(). For more information, see the section below: strftme function formats.
Use GMT Set this to true to parse timestamp in GMT instead of local time.
Use Advanced Properties Select this check box to turn on the Array Size parameters
Array Size Used when there is an array of data type STRING that must be converted to an array of TIMESTAMP.
If the input variable is a single STRING variable, enter the size of 1.

Input tab

Parameter Description
String The input STRING with the date and time formatting specified by the Format parameter to convert to a TIMESTAMP.
Count to Parse The number of items in the array to format (this can be less than the maximum array size).

Output tab

Parameter Description
Output The output TIMESTAMP variable.

Adding a Custom format

The Time Formatter action also lets you define a Custom format for the input string.

For information on the Custom format option, see Time Formatter.