How to Change the Time in Sql to a Datetime

When I run a sql query the Time colum brings back a number

But in the reports online they are in a datetime format

How do I get the Number into a datetime via SQL?

eg 1339405591826 To 06/11/2012 11:06:31