Datetime formats

Specify a custom format when you convert a datetime value to a string value by using the predefined formats available in Automation Workspace.

The To string action enables you to convert a datetime value to a string value. This action also enables you to select a predefined datetime format or specify a custom format.

Predefined datetime format

When you convert a datetime value to a string value, the predefined datetime formats are available in the Formats list. The following predefined datetime formats are available:
  • BASIC_ISO_DATE: Converts the datetime value to a yyyymmdd+offset value string value.
  • ISO_LOCAL_DATE: Converts the datetime value to a yyyy-mm-dd string value.
  • ISO_OFFSET_DATE: Converts the datetime value to a yyyy-mm-dd+offset value string value. The offset value indicates the difference between the local time and UTC in hours and minutes.
  • ISO_DATE: Converts the datetime value to a yyyy-mm-dd+offset value or yyyy-mm-dd string value. The system adds an offset value if it is available.
  • ISO_LOCAL_TIME: Converts the datetime value to a hh:mm:ss.SSS string value.
  • ISO_OFFSET_TIME: Converts the datetime value to a hh:mm:ss.SSS+offset value string value. The offset value indicates the difference between the local time and UTC in hours and minutes.
  • ISO_TIME: Converts the datetime value to a hh:mm:ss.SSS, or hh:mm:ss.SSS+offset value string value. The offset value indicates the difference between the local time and UTC in hours and minutes.
  • ISO_LOCAL_DATE_TIME: Converts the datetime value to a yyyy-mm-ddThh:mm:ss.SSS string value.
  • ISO_OFFSET_DATE_TIME: Converts the datetime value to a yyyy-mm-ddThh:mm:ss.SSS+offset value string value. The offset value indicates the difference between the local time and UTC in hours and minutes.
  • ISO_ZONED_DATE_TIME: Converts the datetime value to a yyyy-mm-ddThh:mm:ss.SSS+offset value[zone id] string value. The offset value indicates the difference between the local time and UTC in hours and minutes. The 'zone id' in the format represents the time zone.
  • ISO_DATE_TIME: Converts the datetime value to a yyyy-mm-ddThh:mm:ss.SSS, yyyy-mm-ddThh:mm:ss.SSS+offset value, or yyyy-mm-ddThh:mm:ss.SSS+offset value[zone id] string value.
  • ISO_ORDINAL_DATE: Converts the datetime value to a yyyy-[day of the year], or yyyy-[day of the year]+offset value string value. For example, if the datetime value is 'January 25, 2018', it is formatted as '2018-25' where '25' indicates the day of the year.
  • ISO_WEEK_DATE: Converts the datetime value to a yyyy-[week of the year]-[day of the week], or yyyy-[week of the year]-[day of the week]+offset value string value. For example, if the datetime value is 'January 25, 2018', it is formatted as '2018-W4-4' where 'W4' indicates that it is the fourth week of the year and '4' indicates the day of that week.
  • ISO_INSTANT: Converts the datetime value to a yyyy-mm-ddThh:mm:ss.SSSZ string value.
  • RFC_1123_DATE_TIME: Converts the datetime value to a [day of the week], [day of the month] [month in 'MMM' format] [year in 'YYYY' format] hh:mm:ss, or [day of the week], [day of the month] [month in 'MMM' format] [year in 'YYYY' format] hh:mm:ss+offset value string value. For example, if the datetime value is '2018-01-25 10:15', it is formatted as 'Thu, 25 December 2018 10:15:00GMT'. The 'GMT' indicates that there is no offset available.

To specify a custom datetime format using predefined conventions, see Custom datetime formats