I would like to select hour and minutes from datetime. I would like to convert @MyDate so it becomes '09:05'
When I do following I get '9:5' How do I convert to get zero as well?
DECLARE @MyDate datetime='2015-03-16 09:05:57.000'
CAST(DATEPART(HOUR, @MyDate) as varchar(50))+':'+CAST(DATEPART(MINUTE,@MyDate) as varchar(50))