You could try :
SELECT CAST(ROWDATE AS TIMESTAMP(0))+
CAST(STARTTIME/100 AS INTERVAL HOUR(2))+
CAST(STARTTIME MOD 100 AS INTERVAL MINUTE(2))
Its working for me. Thanks a lot.. you are genius :)
I want to do reverse of this one as well.
Input as timestamp :