Date and Time Pattern Letters - MaxMaeder/DriveBackupV2 GitHub Wiki
A date or time pattern letter represents a date or time component, such as the day of week or hour of the day. The DriveBackupV2 docs state when text should or can contain date and time pattern letters.
If you want to include normal words in some text that accepts date and time pattern letters, you must surround that text with single quotes, and the entirety of the text with double quotes.
Pattern letters are usually repeated, as their number determines the exact presentation:
-
Text: If the number of pattern letters is 4 or more, the full form is used; otherwise a short or abbreviated form is used if available.
-
Number: The number of pattern letters is the minimum number of digits, and shorter numbers are zero-padded to this amount.
Shortcuts
%FORMAT
foryyyy-M-d--HH-mm
(e.g.2021-7-4--13-30
)
List of Date and Time Pattern Letters
Letter | 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 |
Taken from docs.oracle.com.