I know I asked this before, but I can't find the answer.
I have an SQL table that has a date field. A piece of the SQL stored procedure that returns the date is:
CONVERT(varchar,duration,14) AS duration
It comes back as: hh:mm:ss:mss
I need it: hh:mm:ss:ms
I would swear it worked at one time...
I would prefer to fix it on the SQL side as this store procedure is used in many places.