[RESOLVED] Time Convertion

[vplag]

Hello gurus,
i have one field that the type is smalldatetime into the data base.
the data that exist into this field is like
31/5/2006 11:57:06 am

i want to take from this table only the time....
11:57:06.

how is this possible????

i'm using
CONVERT(datetime, RIGHT(CONVERT(varchar, StartTime), 7))

return me 11:57:00. but where are six seconds?????

Thanks

[vplag]

i found it gurus!!!!


CONVERT(char, EndTime, 108)

Thanks anyway