Export (0) Print
Expand All
Expand Minimize

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:
© 2014 Microsoft