Formatação de Campos

Discussão em 'Comandos Básicos' iniciado por fdantas, Fevereiro 2, 2009.

  1. fdantas

    fdantas Administrator Moderador

    Alguns exemplos de formatação de campos

    CHARACTER x(8)
    DATE 99/99/99
    DATETIME 99/99/9999 HH:MM:SS.SSS
    DATETIME-TZ 99/99/9999 HH:MM:SS.SSS+HH:MM
    DECIMAL ->>,>>9.99
    HANDLE2 >>>>>>9
    INT64 ->,>>>,>>9
    INTEGER ->,>>>,>>9
    LOGICAL yes/no

    Formatação de Datas


    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 Check this option when you want to include the time portion in the format.

    Time format Use this option to 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.

    These options are only available when you select Include time.

    Decimal places for seconds Use this option to 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.

    This option is only available when you select Include time.

    12 hour format (AM/PM Use this option to specify a 12 hour time format. When you select this format hours are displayed using AM or PM.

    This option is only available when you select Include time.

    Standard Select this option to format the selected field to the default ABL DateTime format: 99/99/9999 HH:MM:SS.SSS+HH:MM.

Compartilhe esta Página