Chapter 5 Database Options
213
TIME_FORMAT option
Sets the format for times retrieved from the database.
A string composed of the symbols listed below.
Can be set for an individual connection or for the PUBLIC group. Takes
effect immediately.
HH:NN:SS.SSS
For Open Client and JDBC connections the default is 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...] 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.
TIMESTAMP_FORMAT option
Sets the format for timestamps that are retrieved from the database.
A string composed of the symbols listed below.
Can be set for an individual connection or for the PUBLIC group. Takes
effect immediately.
YYYY-MM-DD HH:NN:ss.SSS
For Open Client and JDBC connections the default is set to YYYY-MM-DD
HH:NN:SS.SSS.
The format is a string using the following symbols:
Function
Allowed values
Scope
Default
Description
Function
Allowed values
Scope
Default
Description
To Next Page
Loading...