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
, 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 |