Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

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
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 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!).

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (14)
As of 2014-10-24 15:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (132 votes), past polls