BitWise MnM (3/25/2012)

---

thanks, probably the best working code dealing with the subject. I replaced the datetime with time(0), just easier on my eyes:

CAST(STUFF(STUFF(REPLACE(STR(run_time, 6), ' ', '0'), 3, 0, ':'),...

I admit I wrote some pretty bad code and forgot to replace "history." with "jh.", but that's been fixed. During the testing process I did a little edge testing...

I've been chasing this issue as well, and stumbled across the same code that the original poster found. Unfortunately, that code, which I traced back as early as 2002,...