sr_time_format option [SQL Remote]

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 symbols:

Symbol	Description
HH	Two-digit hours (24-hour clock).
NN	Two-digit minutes.
MM	Two-digit minutes if following a colon (as in HH:MM).
SS.SSSSSS	Seconds and fractions of a second, up to six decimal places. Not all platforms support timestamps to a precision of six places.

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.