SET SECONDS Command
Specifies whether seconds are displayed in the time portion of a DateTime value.
(Default) Specifies that seconds are displayed in DateTime values.
Specifies that seconds are not displayed in DateTime values.
The following example demonstrates the effect of the SET SECONDS setting on the time value returned by DATETIME( ). When SET SECONDS is ON, the time value is displayed with the seconds portion. When SET SECONDS is OFF, the time value is displayed without the seconds portion.
SET SECONDS ON CLEAR ? DATETIME( ) && Displays time value with the seconds portion SET SECONDS OFF && Displays time value without the seconds portion ? DATETIME( )