Sets the format used for times retrieved from the database.
A string composed of the symbols HH, NN, MM, SS, separated by colons.
'HH:NN:SS.SSS'
For Open Client and JDBC connections the default is also set to HH:NN:SS.SSS.
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...s] – Two-digit seconds plus optional fraction.
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 in uppercase, which causes the substituted characters also to be in uppercase. For numbers, using mixed case in the format string suppresses leading zeros.
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.