Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Converting UNIX timestamp to datetime MYSQL

by maicon1121 (Initiate)
on May 09, 2012 at 12:56 UTC ( #969613=perlquestion: print w/ replies, xml ) Need Help??
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
Re: Converting UNIX timestamp to datetime MYSQL
by 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 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!).

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://969613]
Front-paged by Corion
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (4)
As of 2015-11-28 20:52 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (744 votes), past polls