Data Transformation Engine Type Designer Reference Guide

Chapter 5 - Item Properties Date & Time Item Subclass Properties

Note After you define and save a custom format, the custom format string appears in

the Properties window. For example, the custom date format CCYYMMDD, and

the custom time format HH24MMSS display as:

{CCYYMMDD}{HH24MMSS}

Custom Time Format

After choosing Custom from the time format drop-down list, click browse. The

Time Format dialog box appears.

Note You can only use non-alphanumeric characters as separators (excluding the {, }

and [, ] non-alphanumeric characters) in the Time Format dialog box.

The following table provides detailed information about time formats.

Time Format Description Example

HH24 2-digit hour in 24 hour format (00-23)

H24 1- or 2-digit hour in 24 hour format (1-12)

HH12 2-digit hour in 12 hour format (01-12)

H12 1- or 2-digit hour in 12 hour format (1-12)

MM 2-digit minute (00-59)

M 1- or 2-digit minute (0-59)

SS 2-digit second (00-59)

S 1- or 2-digit second (0-59)

AM/PM Meridian (AM/PM)