Hi

You might try

SELECT CONVERT(VARCHAR,DATEADD(s,DateDiff(s, '2005-12-24 12:00:00', '2005-12-24 13:00:01'),'1 Jan, 1900'),108)

This should work fine as long as the difference between the two dates is never more than 23:59:59

Regards

Rich