
Notes
Valid format types in teradatamlspk:
* Formatter for Numeric types:
+----------------------------------------------------------------------------+
|    FORMAT          DESCRIPTION                                             |
+----------------------------------------------------------------------------+
|    ,               A comma in the specified position.                      |
|                    A comma cannot begin a number format.                   |
|                    A comma cannot appear to the right of a decimal         |
|                    character or period in a number format.                 |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    1234             9,999             1,234     | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|   .                A decimal point.                                        |
|                    User can only specify one period in a number format.    |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    123.46             9999.9             123.5  | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    $               A value with a leading dollar sign.                     |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    1234             $9999              $1234    | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    0               Leading zeros.                                          |
|                    Trailing zeros.                                         |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    1234             09999              01234    | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    9               A value with the specified number of digits with a      |
|                    leading space if positive or with a leading minus       |
|                    if negative.                                            |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    1234             9999              1234      | |
|                        |    1234             999               ####      | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    B               Blank space for the integer part of a fixed point number|
|                    when the integer part is zero.                          |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    0.1234             B.999          Blank space| |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    C               The ISO currency symbol as specified in the ISOCurrency |
|                    element in the SDF file.                                |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    234              C999              USD234    | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    D               The character that separates the integer and fractional |
|                    part of non-monetary values.                            |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    234.56           999D9             234.6     | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    EEEE            A value in scientific notation.                         |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    234.56           9.9EEEE             2.3E+02 | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    G               The character that separates groups of digits in the    |
|                    integer part of non-monetary values.                    |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    123456           9G99G99           1,234,56  | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    L               The string representing the local currency as specified |
|                    in the Currency element according to system settings.   |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    234              L999              $234      | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    MI              A trailing minus sign if the value is negative.         |
|                    The MI format element can appear only in the last       |
|                    position of a number format.                            |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    -1234            9999MI            1234-     | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    PR              A negative value in <angle brackets>, or                |
|                    a positive value with a leading and trailing blank.     |
|                    The PR format element can appear only in the last       |
|                    position of a number format.                            |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    -1234            9999PR            <1234>    | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    S               A negative value with a leading or trailing minus sign. |
|                    a positive value with a leading or trailing plus sign.  |
|                    The S format element can appear only in the first or    |
|                    last position of a number format.                       |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    +1234            S9999             +1234     | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    TM              (text minimum format) Returns the smallest number of    |
|                    characters possible. This element is case insensitive.  |
|                    TM or TM9 return the number in fixed notation unless    |
|                    the output exceeds 64 characters. If the output exceeds |
|                    64 characters, the number is returned in scientific     |
|                    notation.                                               |
|                    TME returns the number in scientific notation with the  |
|                    smallest number of characters.                          |
|                    You cannot precede this element with an other element.  |
|                    You can follow this element only with one 9 or one E    |
|                    (or e), but not with any combination of these.          |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    1234             TM                1234      | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    U              (dual currency) The string that represents the dual      |
|                    currency as specified in the DualCurrency element       |
|                    according to system settings.                           |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    1234             U9999             $1234     | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    V               A value multiplied by 10 to the n (and, if necessary,   |
|                    rounded up), where n is the number of 9's after the V.  |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    1234             9999V99           123400    | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    X               The hexadecimal value of the specified number of digits.|
|                    If the specified number is not an integer, the function |
|                    will round it to an integer.                            |
|                    This element accepts only positive values or zero.      |
|                    Negative values return an error. You can precede this   |
|                    element only with zero (which returns leading zeros) or |
|                    FM. Any other elements return an error. If you do not   |
|                    specify zero or FM, the return always has one leading   |
|                    blank.                                                  |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    1234             XXXX              4D2       | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+

* Formatter for Date types:
+----------------------------------------------------------------------------+
|    FORMAT          DESCRIPTION                                             |
+----------------------------------------------------------------------------+
|    -                                                                       |
|    /                                                                       |
|    ,               Punctuation characters are ignored and text enclosed in |
|    .               quotation marks is ignored.                             |
|    ;                                                                       |
|    :                                                                       |
|    "text"                                                                  |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    03/09/17         MM-DD             09-17     | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    AD              AD indicator.                                           |
|    A.D.                                                                    |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    03/09/17         CCAD              21AD      | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    AM              Meridian indicator.                                     |
|    A.M.                                                                    |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    03/09/17         CCAM              21AM     | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    BC                                                                      |
|    B.C.            BC indicator.                                           |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    03/09/17         CCBC              21BC      | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    CC              Century.                                                |
|    SCC             If the last 2 digits of a 4-digit year are between 01   |
|                    and 99 inclusive, the century is 1 greater than the     |
|                    first 2 digits of that year.                            |
|                    If the last 2 digits of a 4-digit year are 00, the      |
|                    century is the same as the first 2 digits of that year. |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    03/09/17         CCBC              21BC      | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    D               Day of week (1-7).                                      |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    03/09/17         D                 4         | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    DAY	         Name of day.                                            |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    03/09/17         DAY               WEDNESDAY | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    DD              Day of month (1-31).                                    |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    03/09/17         DD                17        | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    DDD             Day of year (1-366).                                    |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    03/09/17         DDD               260       | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    DL              Date Long. Equivalent to the format string ‘FMDay,      |
|                    Month FMDD, YYYY’.                                      |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        | data       formatter         result             | |
|                        +-------------------------------------------------+ |
|                        | 03/09/17   DL      Wednesday, September 17, 2003| |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    DS              Date Short. Equivalent to the format string             |
|                    ‘FMMM/DD/YYYYFM’.                                       |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    03/09/17         DS                9/17/2003 | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    DY              abbreviated name of day.                                |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        |    data             formatter         result    | |
|                        +-------------------------------------------------+ |
|                        |    03/09/17         DY                WED       | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    FF              [1..9]	Fractional seconds.                            |
|                    Use [1..9] to specify the number of fractional digits.  |
|                    FF without any number following it prints a decimal     |
|                    followed by digits equal to the number of fractional    |
|                    seconds in the input data type. If the data type has no |
|                    fractional digits, FF prints nothing.                   |
|                    Any fractional digits beyond 6 digits are truncated.    |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  FF         000000   | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    HH                                                                      |
|    HH12           Hour of day (1-12).                                      |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  HH         09       | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    HH24	        Hour of the day (0-23).                                  |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  HH24         09     | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    IW             Week of year (1-52 or 1-53) based on ISO model.          |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  IW         01       | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    IYY                                                                     |
|    IY             Last 3, 2, or 1 digits of ISO year.                      |
|    I                                                                       |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  IY         16       | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    IYYY	        4-digit year based on the ISO standard.                  |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  IYYY         2016   | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    J              Julian day, the number of days since January 1, 4713 BC. |
|                   Number specified with J must be integers.                |
|                   Teradata uses the Gregorian calendar in calculations to  |
|                   and from Julian Days.                                    |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  J          2457394  | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    MI             Minute (0-59).                                           |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  MI         08       | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    MM             Month (01-12).                                           |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  MM         01       | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    MON	        Abbreviated name of month.                               |
|                    Example:                                                |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  MON        JAN      | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    MONTH	        Name of month.                                           |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  MONTH      JANUARY  | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    PM                                                                      |
|    P.M.           Meridian indicator.                                      |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  HHPM       09PM     | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    Q              Quarter of year (1, 2, 3, 4).                            |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  Q       1           | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    RM             Roman numeral month (I - XII).                           |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  RM         I        | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    SP             Spelled. Any numeric element followed by SP is spelled in|
|                   English words. The words are capitalized according to how|
|                   the element is capitalized.                              |
|                   For example: 'DDDSP' specifies all uppercase, 'DddSP'    |
|                   specifies that the first letter is capitalized, and      |
|                   'dddSP' specifies all lowercase.                         |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  HHSP       NINE     | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    SS             Second (0-59).                                           |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  SS         03       | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    SSSSS	        Seconds past midnight (0-86399).                         |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  SSSSS      32883    | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    TS             Time Short. Equivalent to the format string              |
|                   'HH:MI:SS AM'.                                           |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  TS     09:08:01 AM  | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    TZH	        Time zone hour.                                          |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  TZH        +00      | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    TZM	        Time zone minute.                                        |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  TZM        00       | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    TZR	        Time zone region. Equivalent to the format string        |
|                   'TZH:TZM'.                                               |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  TZR        +00:00   | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    WW             Week of year (1-53) where week 1 starts on the first day |
|                   of the year and continues to the 7th day of the year.    |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  WW         01       | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    W              Week of month (1-5) where week 1 starts on the first day |
|                   of the month and ends on the seventh.                    |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  W          1        | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    X              Local radix character.                                   |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  MMXYY      01.16    | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    Y,YYY	        Year with comma in this position.                        |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                        formatter  result   | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  Y,YYY      2,016    | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    YEAR           Year, spelled out. S prefixes BC dates with a minus sign.|
|    SYEAR                                                                   |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                     formatter  result      | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  YEAR  TWENTY SIXTEEN| |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    YYYY                                                                    |
|    SYYYY          4-digit year. S prefixes BC dates with a minus sign.     |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                     formatter  result      | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  YYYY    2016        | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+
|    YYY            Last 3, 2, or 1 digit of year.                           |
|    YY             If the current year and the specified year are both in   |
|    Y              the range of 0-49, the date is in the current century.   |
|                   Example:                                                 |
|                        +-------------------------------------------------+ |
|                        | data                     formatter  result      | |
|                        +-------------------------------------------------+ |
|                        | 2016-01-06 09:08:01.000000  YY      16          | |
|                        +-------------------------------------------------+ |
+----------------------------------------------------------------------------+

