DECLARE
@Date DATETIME
SET @Date ='1900-01-01 19:02:33'
SELECT CONVERT(VARCHAR,@Date);
SELECT SUBSTRING(CONVERT(VARCHAR, @Date,120), 1, 17) + '00';