Configure date/time settings (DB2®)

When you configure Unica Campaign for multiple locales on DB2®, be sure to adjust the date and time values.

About this task

Choose Settings > Configuration, then specify the values for the properties listed in the following table.

Property

Value

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

%Y-%m-%d

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

DT_DELIM_Y_M_D

Campaign > partitions > partition[n] > dataSources > [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