Log out?

Our Blog

Date and Time Formatting in PilotFish Data Mapper


The PilotFish Date and Time Formatter in our Data Mapper is a powerful tool for reformatting date and time strings. By defining the structure of both the input and output dates, PilotFish is able to instantly transform the format without losing any data.

If unfamiliar with date and time patterns, defining one may seem intimidating at first, however, they are really quite simple. A date and time pattern is a series of characters that refer to different components of the date & time. For example, M is for the month, y for the year, h for the hour, etc.

NOTE: It is important to remember that date and time patterns are case-sensitive. For example, M is month, while m is minute.

A common date and time format example is: 2018-01-01 13:01:01.123. That string has all the main components of a date/time format: year, month, day, hour, minute, second, millisecond. As a pattern, it would be: yyyy-MM-dd HH:mm:ss.SSS. It’s important to note the capital H, which is used for hours in the 24-hour format. AM and PM use the lower-case h.

All Pattern Characters

The following is a list of all pattern characters. PilotFish supports all the patterns from Java’s SimpleDateFormat API.

LetterDate or Time ComponentPresentationExamples
GEra designatorTextAD
yYearYear1996; 96
YWeek yearYear2009; 09
MMonth in year (context sensitive)MonthJuly; Jul; 07
LMonth in year (standalone form)MonthJuly; Jul; 07
wWeek in yearNumber27
WWeek in monthNumber2
DDay in yearNumber189
dDay in monthNumber10
FDay of week in monthNumber2
EDay name in weekTextTuesday; Tue
uDay number of week (1 = Monday, …, 7 = Sunday)Number1
aAm/pm markerTextPM
HHour in day (0-23)Number0
kHour in day (1-24)Number24
KHour in am/pm (0-11)Number0
hHour in am/pm (1-12)Number12
mMinute in hourNumber30
sSecond in minuteNumber55
zTime zoneGeneral time zonePacific Standard Time; PST; GMT-08:00
ZTime zoneRFC 822 time zone-0800
XTime zoneISO 8601 time zone-08; -0800; -08:00

More Information

For more information, please check the Java documentation on date formatting at this link: Simple Date Format

This is a unique website which will require a more modern browser to work! Please upgrade today!