Configure date/time settings (DB2)

On the Marketing Platform Configuration page, set the following values for the following date/time properties:

Property

Value

Campaign > partitions > partition[n] > [data_source_name] > DateOutputFormatString

%Y-%m-%d

Campaign > partitions > partition[n] > [data_source_name] > DateTimeFormat

DT_DELIM_Y_M_D

Campaign > partitions > partition[n] > [data_source_name] > DateTimeOutputFormatString

%Y-%m-%d %H:%M:%S

For Japanese databases, the delimiter for the time portion must be a period (.) So, for Japanese databases set the value to:

%Y/%m/%d %H.%M.%S

IBM Unica Campaign
 
8.5.0
Copyright IBM Corporation 2011. All Rights Reserved.
For more information, see our support and community site: Customer Central