ASA Database Administration Guide
  Database Options
    Alphabetical list of options

TIME_FORMAT option [compatibility]

Function 

Sets the format for times retrieved from the database.

Allowed values 

String, composed of the symbols listed below.

Scope 

Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.

Default 

HH:NN:SS.SSS

Description 

The format is a string using the following symbols:

• hh    Two digit hours (24 hour clock)

• nn    Two digit minutes

• mm    Two digit minutes if following a colon (as in hh:mm)

• ss[.s...]    Two digit seconds plus optional fraction

Each symbol is substituted with the appropriate data for the time that is being formatted. Any format symbol that represents character rather than digit output can be put in uppercase, which causes the substituted characters to also be in uppercase. For numbers, using mixed case in the format string suppresses leading zeros.