|
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.
|