Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Time comparison

by selva (Scribe)
on Mar 06, 2009 at 14:41 UTC ( #748872=perlquestion: print w/ replies, xml ) Need Help??
selva has asked for the wisdom of the Perl Monks concerning the following question:

I need to compare epoch time and postgresql timestamp. In my code first i take time field from database. And get the current time using time() function.

convert the postgresql timestamp to epoch time using Time::Local module. Then subtract postgresql timestamp from current time for my purpose. Is there any way to directly compare postgresql timestamp and epoch time without using Time::Local module.

use Time::Local; $msgtime = SelectTimeFromDatabase($MRequestId); $curtime = time(); #time stamp format in database - 06/03/2009 16:37:47.08812 $msgtime =~ /^(\d+)\/(\d+)\/(\d+) (\d+):(\d+):(\d+)\..*$/; $month = $2 - 1 ; # timelocal($sec,$min,$hour,$mday,$mon,$year); $msgtime = timelocal($6,$5,$4,$1,$month,$3); return ( ($curtime - $msgtime) >= 30 ? 1 : 0 );

Comment on Time comparison
Download Code
Re: Time comparison
by Anonymous Monk on Mar 06, 2009 at 14:45 UTC
    Select an epoch from postgresql, compare it to time... see postgresql manual

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (11)
As of 2014-12-19 13:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (83 votes), past polls