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
Copyright IBM Corporation 2012. All Rights Reserved.