We have a SQL 2005 database that has the time stored as an integer.  I'm
assuming it is the seconds after midnight.  Is there a function to convert
this to a readable time?
Thanks

I have a table that has a Sales Tax Code and an Invoice Date (ex. 7/04/07)
and another table that has the Sales Tax Code, Tax Rate, and Effective Date.  
The second table can have the same Sales Tax Code with a different Tax Rate
and Effective Date.  I want to select only one Tax ...