08-02-02, 10:58 #1Registered User
- Join Date
- Aug 2002
Unanswered: How do I convert UNIX timestamp to mm/dd/yyyy hh:mm:ss format?
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