Converting UNIX timestamp to datetime MYSQL

[maicon1121]

Hey guys, good news, problem solved! as I did the "SELECT" at timestamp 2 times, I needed another variable in my "while", could even be called $ timestamp, but had to be at the end of the while, this solved the problem. Thank you.

[Anonymous Monk]

how can i do this?

You type mysql datetime into the search box and press search, and you find Converting MySQL datetime values to DateTime objects

You type unix mysql into the search box and press search, and you find MySQL, UNIX_TIMESTAMP() and Perl's time()

Repeat until you're satisfied

[sundialsvc4]

In addition to the foregoing, I find it very useful to employ Date::Manip::Objects as a sort of universal-toolkit for all things Date&Time.   A search of http://search.cpan.org for date and time is a very fruitful thing to do, because you will find a ready-made solution to just about anything in there. (DateTime::Calendar::Mayan, DateTime::Calendar::VikramaSamvata::Gujarati ... it’s actually fun to see all the things that people have come up with.)   Since date/time is a pretty universal PITA for computer programmers, everything about it has been thoroughly addressed ... which saves you a lot of (you guessed it!).