Date and Time Pattern Strings

Virtual DataPort uses the date and time Java patterns to specify date and time formats. In these patterns, the letters of the first column represent parts of a date.

Java Date and time patterns used in Virtual DataPort
Symbol Date or Time Component Presentation Examples
G Era designator Text AD
y Year Year 1996; 96
M Month in year Month July; Jul; 07
w Week in year Number 27
W Week in month Number 2
D Day in year Number 189
d Day in month Number 10
F Day of week in month Number 2
E Day in week Text Tuesday; Tue
a Am/pm marker Text PM
H Hour in day (0-23) Number 0
k Hour in day (1-24) Number 24
K Hour in am/pm (0-11) Number 0
h Hour in am/pm (1-12) Number 12
m Minute in hour Number 30
s Second in minute Number 55
S Millisecond Number 978
z Time zone General time zone Pacific Standard Time; PST; GMT-08:00
Z Time zone RFC 822 time zone -0800
Escape character for text   (not displayed)
Single inverted comma Literal

In the table above, different values are used to indicate the arrangement of reserved characters. The specific output format depends on the number of times the different elements are repeated in each position:

  • Text: use 4 or more characters to specify complete form; less than 4 characters to use the abbreviated form. For instance, if a date pattern specifies EEEE in the day of the week position, it indicates that day of the week should be shown using the complete form (e.g. “Monday”) instead of the abbreviated form (e.g. “Mon”).
  • Number: it always uses the minimum number of digits possible. 0s are added to the left of the shortest numbers if required. The year is a special case: if the number of “y” is 2, the year is shortened to 2 digits.
  • Text & Number: 3 or more characters to represent it as text; otherwise a number is used. For instance, if a date pattern specifies MMM in the month position, it indicates that months should be shown using the text name (e.g. “Jul”). If the pattern specifies MM, the month will be shown as a number. In a date format the characters that are not found in the ranges ['a'..'z'] or ['A'..'Z'] are considered constants, i.e. characters such as ':', '.', ' ', '#' and '@' appear in the resulting date, although they are not in inverted commas in the format pattern.