Appendix : Legacy Presto components : Mashables and Mashups : Mashups in Business Analytics Wires : Creating Mashups in Wires : Add Actions or Other Blocks : Built-in Functions for Decorator, Mapper and Transformer Blocks : Date Formatter
Date Formatter
Changes the format of a date, time or date and time field that you map to this output field. If you have not already mapped this output field, click in the Select a Date property to open the Path Selector and map a field.
Then define the format of the input date and/or time and the output format you want for this date and/or time. For both properties, you can:
*Select an existing format string.
*Enter a format string directly.
*Or click to open the Path Selector to supply the formats from input fields or fields from any block results in this mashup.
Format strings for dates and times use letters and symbols in a pattern indicating what each character in the date or time represents. The most common patterns for format strings include:
Pattern
Usage
a
AM or PM for 12-hour times
dd
2-digit day of the month, such as 05
EEE
3-character abbreviation of the day of the week, such as Thu
EEEE
full name of the day of the week, such as Thursday
HH
2-digit hour in a 24 hour clock (0-23)
hh
2-digit hour in a 12 hour clock (01-12)
mm
2-digit minutes
MM
2-digit month, such as 12
MMM
3-character month abbreviation, such as Dec
MMMM
Full month by name, such as December
ss
2-digit seconds
sss
3-digit milliseconds
yyyy
4-digit year, such as 2005
z
Timezone
You can combine this with /, - or . as delimiters between portions of the date. Times always use : and . delimiters. For example:
01/29/2010 01:15:01.45AM uses MM/DD/YYYY hh:mm:ss.Sa
31-03-2001 uses DD-MM-YYY
21:00 uses HH:mm
The complete list of characters and symbols that are valid in patterns are defined in the java.text.SimpleDateFormat class. For detailed information, see Java API documentation for the JDK version used in your environment.
Copyright © 2013-2017 Software AG, Darmstadt, Germany. (Innovation Release)

Product LogoContact Support   |   Community   |   Feedback