Export (0) Print
Expand All
Expand Minimize
1 out of 1 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.