Configure date/time settings (Oracle)
When you configure Unica Campaign for multiple locales on Oracle, 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 |
---|---|
Unica Campaign > partitions > partition[n] > dataSources > [data_source_name] > DateFormat |
DELIM_Y_M_D |
Unica Campaign > partitions > partition[n] > dataSources > [data_source_name] > DateOutputFormatString |
%Y-%m-%d |
Unica Campaign > partitions > partition[n] > dataSources > [data_source_name] > DateTimeFormat |
DT_DELIM_Y_M_D |
Unica 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 |
Unica Campaign > partitions > partition[n] > dataSources > [data_source_name] > SQLOnConnect |
With Native (without Oracle ODBC) ALTER SESSION SET NLS_LANGUAGE='American' NLS_TERRITORY='America' NLS_TIMESTAMP_FORMAT='YYYY-MM-DD hh24:mi:ss' NLS_DATE_FORMAT='YYYY-MMDD' Non-native(Via ODBC) ALTER SESSION SET NLS_LANGUAGE='American' NLS_TERRITORY='America' NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH24:MI:SSXFF' NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' |