Options List ‐ Date - tablacus/TablacusExplorer GitHub Wiki
Customize the format of date type columns
| Code | Description | ||
|---|---|---|---|
| Date | d | Day of the month | |
| dd | Day of the month with leading zero | ||
| ddd | Day of the week (3-letter abbreviation) | In local language | |
| dddd | Day of the week | In local language | |
| M | Month | ||
| MM | Month with leading zero | ||
| MMM | Name of the month (3-letter abbreviation) | In local language | |
| MMMM | Name of the month | In local language | |
| yy | Year (last 2 digits) | ||
| yyyy | Year | ||
| Time | h | Hours (12-hour clock) | |
| hh | Hours (12-hour clock) with leading zero | ||
| H | Hours (24-hour clock) | ||
| HH | Hours (24-hour clock) with leading zero | ||
| m | Minutes | ||
| mm | Minutes with leading zero | ||
| s | Seconds | ||
| ss | Seconds with leading zero | ||
| t | 12-hour clock period in 1 character (a / p) | In local language | |
| tt | 12-hour clock period (AM / PM) | In local language | |
| Text | (others) | The character itself |
Example: dddd, d/M/yyyy h:mm:sstt