I have a table that is imported into SQL 2000 from a Sybase box. The date is an integer unix timestamp (number of seconds from 1/1/1970 at midnight). How can I convert this into a format of mm/dd/yyyy hh:mm:ss ?

Thanks in advance