Converting UNIX timestamp to datetime MYSQL

maicon1121 has asked for the wisdom of the Perl Monks concerning the following question:

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.

Comment on Converting UNIX timestamp to datetime MYSQL

Replies are listed 'Best First'.
Re: Converting UNIX timestamp to datetime MYSQL by Anonymous Monk on May 09, 2012 at 13:02 UTC
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	[reply]
Re: Converting UNIX timestamp to datetime MYSQL by locked_user sundialsvc4 (Abbot) on May 09, 2012 at 18:32 UTC
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!).