Get The Time From A DateTime Field

 

I looked at this post and it didn't work for me.

 

Trying to extract the time portion from a datetime field. ex  7:15:12 AM from    1/1/2008 7:15:12 aM

This is what I tried and neither functions give me the results I want....

 SELECT     DueTime, CONVERT(varchar, DueDate, 108) AS Expr1, SUBSTRING(CAST(DueDate AS varchar), 10, LEN(DueDate)) AS Expr2, CAST(DueDate AS varchar)
                       AS Expr3
FROM         TODO

Due Time                              Expr1                Expr2                         Expr3

1/1/2008 5:15:00 PM           00:00:00            12:00:00 AM              Jan 1 2008 12:00:00 AM

It seems Cast(DueDate as varchar) is the problem it converts the time to the default 12:00:00 AM

In the above example I want 5:15:00 PM

 

Tx in advance