sr_time_format option [SQL Remote]

String (composed of the symbols listed below)

hh:nn:ss.Ssssss

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. 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.

Using mixed case in the formatting string suppresses leading zeros.

sr_time_format option [SQL Remote]

Allowed values

Default

Remarks

Remarks

See also