This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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