Question: I want to get only `hh:mm` from date. 

How I can get this?

I have tried this :

```
CONVERT(VARCHAR(8), getdate(), 108)

```

Answer: 
You can easily use Format() function instead of all the casting for sql 2012 and above only

```
SELECT FORMAT(GETDATE(),'hh:mm')

```

This is by far the best way to do the required conversion.
Here is syntax for showing hours and minutes for a field coming out of a SELECT statement. In this example, the SQL field is named "UpdatedOnAt" and is a DateTime. Tested with MS SQL 2014.

```
SELECT Format(UpdatedOnAt ,'hh:mm') as UpdatedOnAt from MyTable

```

I like the format that shows the day of the week as a 3-letter abbreviation, and includes the seconds:

```
SELECT Format(UpdatedOnAt ,'ddd hh:mm:ss') as UpdatedOnAt from MyTable

```

The "as UpdatedOnAt" suffix is optional. It gives you a column heading equal tot he field you were selecting to begin with.