有没有更好的方法将SQL日期时间从hh：mm：ss转换为hhmmss？

I have to write an SQL view that returns the time part of a datetime column as a string in the format hhmmss (apparently SAP BW doesn't understand hh:mm:ss).I have to write an SQL view that returns the ti