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
Use from_unixtime(time/1000) since the DB is in milliseconds.
See more here:
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.