Viewing 3 posts - 1 through 3 (of 3 total)
Much thanks for the help guys!! I really appreciate it. Sorry about the miscalculation on my part.
Steve
August 18, 2003 at 4:06 pm
#470339
Thanks for the response, but that doesn't exactly work. The format I want is hh:mm, not mm:ss.
I modified the query to look like:
select convert(varchar(2), floor(@seconds/3600)) + ':' +
right('0' +...
August 18, 2003 at 2:32 pm
#470331
Much Thanks for all the help from everyone!!
May 1, 2003 at 10:39 pm
#455965