The Format dialog helps you to format the selected Date Time-Tz field.

You can access this dialog by clicking Format Help in the Column Editor dialog (for Browse).

The Format dialog for Date Time-Tz field includes the following options:

Format Enter a valid display format for the selected Date Time-Tz field.
99/99/99 Select to display the date portion in two-byte segments delimited by a backslash (/). This is the standard format.
99-99-99 Select to display the date portion in two-byte segments delimited by a hyphen (-).
99.99.99 Select to display the date portion in two-byte segments delimited by a period (.).
99/99/9999 Select to display the date portion in two-byte segments for the month and day and display the year in four-bytes. Delimit with a backslash (/).
99-99-9999 Select to display the date portion in two-byte segments for the month and day and display the year in four-bytes. Delimit with a hyphen (-).
99.99.9999 Select to display the date portion in two-byte segments for the month and day and display the year in four-bytes. Delimit with a period (.).
999999 Select to display the date portion in six bytes with no delimiter character.
99999999 Select to display the date portion in eight bytes with no delimiter character.
Include Time Select when you want to include the time portion in the format.
Time Format Specify a time format. The option you select determines how the time portion of the format appears. You can select:
  • HH - Displays only the hour.
  • HH:MM - Displays the hour and minutes.
  • HH:MM:SS - Displays the hours, minutes, and seconds.
Note: These options are only available when you select Include time.
Decimal Places for Seconds Select the number of decimal places you want for the second’s portion of the time format. You can select 0, 1, 2, or, 3.
Note: These options are only available when you select Include time.
12 hour format (AM/PM) Select to specify a 12 hour time format. When you select this format hours are displayed using AM or PM.
Include Time Zone Select when you want to include a time zone in the format.
Standard Select to format the selected field to the default ABL DateTime format: 99/99/9999 HH:MM:SS.SSS+HH:MM.