Storage Resource Monitor (SRM)

Forum How to Change the Time in Sql to a Datetime

State Verified Answer
Locked Locked
Replies 3 replies
Subscribers 19 subscribers
Views 1506 views
Users 0 members are here

Options

This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to Change the Time in Sql to a Datetime

bradley22 over 11 years ago

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

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK^® online community. More than 190,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.