W3School TIY Editor

SELECT DATENAME(hour, '2017/08/25 08:36') AS DatePartString;