Time Zone Field Format Strings
The table below lists the format string options for Time Zone fields. Valid string formats depend on the format type you select.
If no format string is specified for a Time Zone field, the value is formatted using the display name for the corresponding time zone. For example: (GMT-06:00) Central Time (US & Canada).
Note: A format string must begin with a % sign and end with a
format type character:
[%] [type]
| Option | Description |
|---|---|
| B | The value is formatted using the bias for the corresponding time zone (for example, 420). The bias is the difference in minutes between Greenwich Mean Time (UTC) and the time zone. |
| DB | The value is formatted using the daylight bias for the corresponding time zone (for example, -60). The daylight bias is the difference in minutes between standard time and daylight time. |
| SB | The value is formatted using the standard bias for the time zone (for example, 0). This value is used during local time translations that occur during standard time. This value is generally 0. |
| SN | The value is formatted using the standard name for the corresponding time zone (for example, Central Standard Time). This value is generally the same as the value stored in the TIMEZONE field. |
| DN | The value is formatted using the daylight name for the time zone (for example, Central Daylight Time). If the time zone does not observe DST then the value is formatted as "N/A". |