Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

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 );

Replies are listed 'Best First'.
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?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://748872]
Approved by Corion
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (6)
As of 2018-03-18 06:47 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (228 votes). Check out past polls.