Date and Time Pattern Letters

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 for yyyy-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.