Specifies whether seconds are displayed in the time portion of a DateTime value.
Syntax
SET SECONDS ON | OFF
Arguments
ON
(Default) Specifies that seconds are displayed in DateTime values.
OFF
Specifies that seconds are not displayed in DateTime values.
Remarks
SET SECONDS is scoped to the current data session.