To configure the flat file properties for datetime data type, you must double-click the flat file that you imported into PowerCenter.

Use the

Format

column of a flat file definition to define the format for each column with datetime data type. You can define the following formatting options for datetime values in the

Column Format Settings

dialog box:

Format string
Field width

The following image shows the format settings that you can configure for a flat file column with the datetime data type:

To specify the datetime format, choose

Format String

and enter the format in the

Format String

field. You can choose a format from the list, or you can enter a format using the keyboard. The default format is MM/DD/YYYY HH24:MI:SS, which has a field width of 19.

To configure datetime values for a flat file, click the

Properties

tab on the

Edit Tables

dialog box.

The following image shows the format settings that you can configure for a flat file for the datetime data type: