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.