Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SET HOURS Command
Collapse the table of content
Expand the table of content

SET HOURS Command

Sets the system clock to a 12- or 24-hour time format.


SET HOURS TO [12 | 24]

Parameters

TO 12

(Default) Specifies a 12-hour format.

TO 24

Specifies a 24-hour format.

Use SET HOURS TO without 12 or 24 to return to the default 12-hour format.

TIME( ) always returns a value in 24-hour format and isn't affected by SET HOURS. The value returned by DATETIME( ) is determined by the current SET HOURS setting.

SET HOURS is scoped to the current data session.

Community Additions

ADD
Show:
© 2015 Microsoft