Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

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
[karlgoethebier]: Hi mario
[marioroy]: Hi karlgoethebier.
[karlgoethebier]: "Long time No See" ;-)
[marioroy]: Yes. I've been working on MCE and MCE::Shared. These are completed and released. MCE 1.830 and MCE::Shared 1.831. Saw the LWP::Simple and P::FM thread and thought to help out.
[marioroy]: Today, wanted to revisit running parallel Re: Crash with ForkManager on Windows. I tried running on Cygwin for comparison.
[marioroy]: Running parallel on Cygwin feels like running on Unix ;-)

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (7)
As of 2017-09-23 15:56 GMT
Find Nodes?
    Voting Booth?
    During the recent solar eclipse, I:

    Results (272 votes). Check out past polls.