Converting SysDate to show 12hour clock

[SA812]

I'm trying to convert this system date to show me the hours and minutes in a 12 hour clock not the 24 hour format that it returns. Is there an easy way to convert to show 12 hour time? I've tried every type of casr nad convert format with no luck

CONVERT (nvarchar(20), LogBBT.SysDate, 8)
i ger :16:31:28

Thank in adavance for your help

 

[markros]

http://forums.asp.net/p/1402208/3037946.aspx#3037946

 

[SA812]

i tried what was in the link:
CONVERT (VARCHAR(10), LogBBT.SysDate, 101) + RIGHT (CONVERT (VARCHAR(20), LogBBT.SysDate, 100), 8)
Result: 03/24/2009 4:31PM

I just want to isolate the Hours & Minutes i do not want the date "3/24/2009"

Thanks,

 

[gmmastros]

Do you want hours and minutes ONLY? Or do you want Hours, Minutes, and Seconds?

If you don't care about seconds....

Select Right(Convert(VarChar(100), LogBBT.SysDate, 100), 7)

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[SA812]

Thanks George!!!
RIGHT (CONVERT (VarChar(100), LogBBT.SysDate, 100), 7)
Result: 4:31PM
worked perfectly!!