Datetime Formats Preferences

Use the Datetime Formats Preferences to modify the appearance of dates and times in the Workflow Editor.

Important: You must be an administrator to edit preferences.

The Datetime formats are used by the Workflow Editor in the following cases:

  • Using the Hadoop File Structure configuration to import datetime data from Hadoop File System text files. See the "Hadoop File" operator help in TIBCO® Data Science Team Studio User's Guide for details.
  • Using the Pig Execute operator to execute Hadoop Pig script against datetime data fields and leverage Pig Datetime functions such as GetMonth(datetime) or GetDay(datetime). See the "Pig Execute" operator help in TIBCO® Data Science Team Studio User's Guide for details.
  • Using the Variable operator to convert source datetime formats into new datetime formats or to convert datetime data into new data fields with a Pig DateTime function. See the "Variable" operator help in TIBCO® Data Science Team Studio User's Guide for details.
  • Using the Set operator to combine two or more data sources that contain datetime data types. See the "Set Operations" in TIBCO® Data Science Team Studio User's Guide for details.
  • Using the Null Value Replacement operator to replace null values with a default datetime format. See the "Null Value Replacement" operator help in TIBCO® Data Science Team Studio User's Guide for details.
  • Using the Row Filter operator to filter data by datetime formats or by a value derived from an applied the Pig Datetime function. See the "Row Filter" operator help in TIBCO® Data Science Team Studio User's Guide for details.

Prerequisites

Procedure

  1. To open the Preferences dialog box, click the Actions menu, and then select Preferences.
  2. Select Datetime Formats.

    Adding a New Datetime Format

    To add a new input datetime format, click Add New Format.

    Click Save to save changes. Click Restore to return to default values.

    Custom Datetime Formats

    Datetime data type formats must follow Joda-Time API formatting. For more information about Joda-Time formatting, see Joda Time Formatting.

    Some commonly used Joda-Time pattern letters include:

    • Uppercase Y refers to the Year of the era (>0); lowercase y refers to the year.
    • Uppercase M refers to the Month of the year; lowercase m refers to the minute of the hour.
    • Uppercase D refers to the Day of the year (1-365); lowercase d refers to the day of the month (1-31).
    • Uppercase E refers to the Day of the week in text (Tuesday); lowercase e refers to the numeric day of the week (1-7).
    • Uppercase H refers to the Hour of the day (1-24); lowercase h refers to the clock hour of the half day (1-12).
    • Uppercase S refers to the Fraction of a Second; lowercase s refers to the second of the minute (1-60).

    The count of pattern letters determines the overall datetime format. For example, YYYY specifies a 4-digit year format, such as 2019.

Related tasks