In sql server, I need to format time part of the datetime field. Such as the datetime value in a column called checkintime is 2006-02-20 20:04:07. I want to format it as 20:04 (just the hour and minutes).
Also, I want to know what is the equivalent in sql server of Visual basic's "##" format mask which, in VB6, always shows two-digit number by left-padding with 0 in case input value is a single-digit number. Thanks