Storage Resource Monitor (SRM)

Forum How to Change the Time in Sql to a Datetime

State Verified Answer
Locked Locked
Replies 3 replies
Subscribers 21 subscribers
Views 1206 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

0 bmrad over 11 years ago

Use from_unixtime(time/1000) since the DB is in milliseconds.
See more here:
MySQL :: MySQL 5.5 Reference Manual :: 12.7 Date and Time Functions
Brian
Cancel
Up 0 Down

Cancel
0 Milton.Harris over 11 years ago

Here is another link that will do the conversion for you:
Online Conversion - Unix time conversion
Cancel
Up 0 Down

Cancel
0 rsneha over 1 year ago

check out this Unix Epoch Time Converter
Cancel
Up 0 Down

Cancel

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.