Please, read my comment to the question. We can't help you to write SP having not enough information.
Solution 1 by
Raja Sekhar S is very good, but i would suggest to change data type of field to
time (T-SQL)[
^] if your MS SQL Server is 2008 or later.
Another way to return only
time
part of date is to use below query (without
RIGHT
function):
SELECT CONVERT(VARCHAR(25), GETDATE(), 114) AS CurrentTime
If you would like to insert time value into table, you shouldn't convert it into varchar data type. Save as it is. To view it, you can always use
CAST and CONVERT (T-SQL) functions[
^].