Configure date/time settings (Oracle)

Property

Value

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

DELIM_Y_M_D

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

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

ALTER SESSION SET NLS_LANGUAGE='American' NLS_TERRITORY='America' NLS_TIMESTAMP_FORMAT='YYYY-MM-DD hh24:mi:ss' NLS_DATE_FORMAT='YYYY-MM-DD'

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