Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Sets the format for TIME values that are retrieved from the database.
The Message Agent uses this option when replicating columns that store a time. The format is a string using the following
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.
Using mixed case in the formatting string suppresses leading zeros.