TIME_FORMAT option

Function

Sets the format used for times retrieved from the database.

Allowed values

A string composed of the symbols HH, NN, MM, SS, separated by colons.

Default

'HH:NN:ss.SSS'

For Open Client and JDBC connections the default is set to HH:NN:SS.SSS.

Description

The format is a string using the following symbols:

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

Note that multibyte characters are not supported in format strings. Only single-byte characters are allowed, even when the collation order of the database is a multibyte collation order like 932JPN. See the section “DATE_FORMAT option” for more information.