SQL Table: dbo.WorkOrder

How can I convert the integer date/time values cotained in dbo.WorkOrder columns: CREATEDTIME, DUEBYTIME, and COMPLETEDTIME?

I am working on creating a new intranet/sharepoint site for one of our clients that will display Open Workorder's, using the following SQL Statement:

SELECT [WORKORDERID] , [CREATEDBYID] , [CREATEDTIME] , [DUEBYTIME] , [COMPLETEDTIME] , [TITLE] FROM [WorkOrder] WHERE [REQUESTERID] = 606 AND [COMPLETEDTIME] = 0

This returns the correct work orders "open" by requester ID, however the date(ed) fields output in a long integer which I am unfamiliar with.

Any assistance would be greatly appreciatetd.

Thanks,

Scott Hasler
Total IP, LLC
Web / Application Dev.

http://www.totalip.net

email: scott.hasler@totalip.net