Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

SET SECONDS Command

Visual Studio .NET 2003

Specifies whether seconds are displayed in the time portion of a DateTime value.

SET SECONDS ON | OFF

Parameters

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.

Example

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( )

See Also

CTOT( ) | DATE( ) | DATETIME( ) | DTOT( ) | HOUR( ) | MINUTE( ) | SEC( ) | SECONDS( ) | SET SECONDS | TIME( )

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.