To set dates for a specific language on your web application

Note: All referenced files are installed by the web application installer unless specifically noted.
Important: webapphome refers to the directory where the Campaign web application was installed. language_code refers to the language setting(s) you choose for your system.
  1. Edit the webapphome/conf/campaign_config.xml file to ensure that language_code is present in the comma-separated list in the <supportedLocales> tag, as shown below:

    <supportedLocales>en_US, language_code</supportedLocales>

  2. In the webapphome/webapp directory, copy the entire directory tree en_US to language_code (case sensitive).
  3. In webapphome/webapp/WEB-INF/classes/resources, copy StaticMessages_en_US.properties to StaticMessages_ language_code.properties. Also copy ErrorMessages_en_US.properties to ErrorMessages_ language_code.properties.
  4. Edit the StaticMessages_ language_code.properties: search for DatePattern and change it to read DatePattern=dd/MM/yyyy (case sensitive).
    Note: This format is defined by Java. Complete detail about the format can be found in Java documentation for java.text.SimpleDateFormat at http://java.sun.com. The StaticMessages.properties file does not need to be modified.
  5. For WebSphere®: Re-jar the web application.
  6. For WebLogic: Remove the current web application module.
    1. Add the new module.
    2. Redeploy the web application.
    3. Restarting the Unica Campaign listener is not necessary.
  7. Ensure that the web browser's language setting has language_codeset to the first priority. For more details, see the sections below, To set your web browser for the correct language and To set your computer to display a specific language.
    Note: Be sure to use a hyphen, as opposed to an underscore, in language_code. The web application configuration is the only place where a hyphen is used instead of an underscore.
  8. Log in to Campaign. Dates should be displayed in Campaign in the format specified in StaticMessages_language_code.properties.

For information on how to configure the time for Unica Campaign, see the Unica Campaign documentation.

Examples

If the time is 10:54 a.m., CURRENT_TIME() will return the string "10:54:00 AM".

Related Functions

Function Description
CURRENT_DAY Returns the current day as a number.
CURRENT_JULIAN Returns the current Julian number.
CURRENT_WEEKDAY Returns the current weekday as a number.
CURRENT_YEAR Returns the current year as a number.