Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Sets the format for times retrieved from the database.
Can be set for an individual connection, or for PUBLIC. You must have the SET ANY PUBLIC OPTION system privilege to set this
option for PUBLIC or for another user or role. Takes effect immediately.
The format is a string using the following symbols:
Each symbol is substituted with the appropriate data for the time that is being formatted.
For symbols that represent numeric data, you can control zero-padding with the case of the symbols:
Type the symbol in same-case (such as NN or nn) to allow zero padding. For example, hh:nn:ss.sss could produce 02:34:56.123.
Type the symbol in mixed case (such as Nn) to suppress zero padding. For example, Hh:nn:ss.sss could produce 2:34:56.123.
If the first two digits of the fractional seconds are mixed case (such as Ss or sSssss) then trailing zeros are removed. For
example, hh:nn:ss.Sss could produce 12:34:56.1.