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.