Custom Time Format
After selecting Custom from the time format list, click browse. The Time Format window is displayed.
You can only use non-alphanumeric characters as separators, excluding the {, } and [, ] non-alphanumeric characters, in the Time Format window.
The following table provides time format examples.
| Time Format | Description | Example |
|---|---|---|
| HH24 | 2-digit hour in 24 hour format (00-23) | 23 |
| H24 | 1- or 2-digit hour in 24 hour format (0-23) | 11 |
| HH12 | 2-digit hour in 12 hour format (00-12) | 08 |
| H12 | 1- or 2-digit hour in 12 hour format (0-12) | 8 |
| MM | 2-digit minute (00-59) | 09 |
| M | 1- or 2-digit minute (0-59) | 9 |
| SS | 2-digit second (00-59) | 05 |
| S | 1- or 2-digit second (0-59) | 5 |
| AM/PM | Meridian (AM/PM) | AM |
| ZZZ | A time zone abbreviation. See "Time Zones" for a list of supported time zones. | EST |
| +/-ZZZZ | Hours and minutes before or after the Greenwich Mean Time (GMT). GMT is now referred to as Coordinated Universal Time (UTC). | +0500 |
| +/-ZZ:ZZ | 4-digit time where the format is a 2-digit hour and 2-digit minute, separated by a colon. | +05:00 |
| +/-ZZ[:ZZ] | 4-digit time where the format is a 2-digit hour and an optional 2-digit minute, separated by colon. | +05:00 |
| +/-ZZ[ZZ] | 4-digit time where the format is a 2-digit hour and an optional 2-digit minute. | +0500 |
| TZD | 4-digit time where the format is a 2-digit hour and 2-digit minute, separated by a colon. Z on output, if value is +/-00:00. | +05:00 |
After you define and save a custom format, the custom format
string is displayed in the Properties window.
For example, the custom date format CCYYMMDD,
and the custom time format HH24MMSS display
as:
{CCYYMMDD}{HH24MMSS}