Placeholders for the Date and Time
The following placeholders for the date and time can be used in the backup options and the general options for the time and date format.Characters | Description |
---|---|
: | Time delimiter |
/ | Date delimiter |
d, dd | Day (1 – 31, 01 – 31) |
Ddd | Abbreviated day of the week (Sun - Sat) |
dddd | Day of the week (Sunday - Saturday) |
ddddd | Short date format |
dddddd | Long date format |
w | Calendar week day (1 for Sunday to 7 for Saturday) |
ww | Calendar week (1 — 54) |
m, mm | Month (1 - 12, 01 – 12) |
mmm | Abbreviated names of the months (Jan - Dec) |
mmmm | Names of the months (January - December) |
q | Quarter (1 – 4) |
y | Calendar day (1 – 366) |
yy, yyyy | Year (00 – 99, 100 - 9999) |
h, hh | Time/hour (0 - 23, 00 - 23) |
m, mm, n, nn | Time/minute (0 - 59, 00 - 59) |
s, ss | Time/second (0 - 59, 00 - 59) |
AM/PM, A/P, AMPM | 12-hour format |