Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
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 making s'mores by the fire in the courtyard of the Monastery: (4)
As of 2015-03-02 04:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When putting a smiley right before a closing parenthesis, do you:









    Results (25 votes), past polls