Q:

How do I show just the time part of a date?

I would like to get just the time portion of a date time using T SQL.  I have found that to get different formats you can use something like this: 
CONVERT(varchar,GETDATE(),108)  ---17:15:00 gives time in 24hr format

I would like to get that as 5:00 PM.

A:

What version of SQL? 2008 and up have several "Time" datatypes, which--if all you need is Time -- is more convenient.
As for layout/presentation, use the CONVERT function with the desired formatting code. Here's a sample of how that can work:
DECLARE @When time

SET @When = getdate()

PRINT @When
PRINT convert(varchar(10), @When, 100)

