| d | The day of the month, from 1 to 31. | 2009-06-01T13:45:30 → 1, 2009-06-15T13:45:30 → 15 |
| dd | The day of the month, from 01 to 31. | 2009-06-01T13:45:30 → 01 |
| ddd | The abbreviated name of the day of the week. | 2009-06-15T13:45:30 → Mon |
| dddd | The full name of the day of the week. | 2009-06-15T13:45:30 → Monday |
| F | Second precision. | 2009-06-15T13:45:30.6170000 → 6 |
| FFF | The milliseconds in a date and time value. | 6/15/2009 13:45:30.617 → 617 |
| FFFFFFF | The ten millionths of a second in a date and time value. | 2009-06-15T13:45:30.6175425 → 6175425 |
| h | The hour, using a 12-hour clock from 1 to 12. | |
| hh | The hour, using a 12-hour clock from 01 to 12. | |
| H | The hour, using a 24-hour clock from 0 to 23. | |
| HH | The hour, using a 24-hour clock from 00 to 23. | |
| o<G> | Time zone information. | 2009-06-15T01:45:30-07:00 → -07:00 |
| m | The minute, from 0 to 59. | |
| mm | The minute, from 00 to 59. | |
| M | The month, from 1 to 12. | |
| MM | The month, from 01 to 12. | |
| MMM | The abbreviated name of the month. | 2009-06-15T13:45:30 → Jun |
| MMMM | The full name of the month. | 2009-06-15T13:45:30 → June |
| s | The second, from 0 to 59. | 2009-06-15T13:45:09 → 9 |
| ss | The second, from 00 to 59. | 2009-06-15T13:45:09 → 09 |
| tt | The AM/PM designator. | 2009-06-15T13:45:30 → PM |
| yy | The year, from 00 to 99. | 0001-01-01T00:00:00 → 01, 2019-06-15T13:45:30 → 19 |
| yyyy | The year as a four-digit number. | 2009-06-15T13:45:30 → 2009 |
| z | IANA Timezone Id | 2024 Sep 09 08:02:16.1 Europe/London → Europe/London |
| : | The time separator | |
| / | The date separator | |