Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

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 all is quiet...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (3)
As of 2018-03-18 04:41 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (228 votes). Check out past polls.