SQL$HELP72.HLB  —  SET  Arguments  TIME time number
    Specifies the display format for time values.

    You must enter a number for the time-number argument. This number
    corresponds to numbers in the time-format logical names listed in
    tables in the OpenVMS run-time library documentation.

    For example, the table contains the logical name
    LIB$TIME_FORMAT_020. The logical name specifies the format in
    which the eighth hour, fourth minute, and thirty-second second of
    a day would be displayed as 8 h 4 min 32 s. Note that the latter
    part of the logical name is the number 020.

    If you wanted to specify the 8 h 4 min 32 s format for the SQL
    SET DATE FORMAT TIME statement, you would use the numeric part
    of the LIB$TIME_FORMAT_020 logical name, 20. You do not have to
    enter any leading zeros that the number might have.

    If you do not specify a time format, the default is hh:mm:ss.cc.
Close Help