Skip site navigation (1) Skip section navigation (2)

Re: Inconsistent results when calculating "age" of db records

From: Raheem Sarcar <raheemm1(at)yahoo(dot)com>
To: "psycopg(at)postgresql(dot)org" <psycopg(at)postgresql(dot)org>
Subject: Re: Inconsistent results when calculating "age" of db records
Date: 2012-07-26 10:02:46
Message-ID: 1343296966.1269.YahooMailNeo@web163906.mail.gq1.yahoo.com (view raw or flat)
Thread:
Lists: psycopg
Ghislain, 

Im ignoring the -1. I assumed that for times when the timedelta is less than 1 day, that item is ignored. But maybe now? Would you mind elaborating on how to get find the hours ago a record was created from something like ( -1, 30319, 123000 )?

Thanks 

- Raheem M. Sarcar


----- Original Message -----
From: Ghislain LEVEQUE <ghislain(dot)leveque(at)clarisys(dot)fr>
To: psycopg(at)postgresql(dot)org
Cc: 
Sent: Thursday, July 26, 2012 1:08 PM
Subject: Re: [psycopg] Inconsistent results when calculating "age" of db records

Le 26/07/2012 08:11, Raheem Sarcar a écrit :

> I get the following output -->
> 11:24:47.082  (which is correct)
>  [...]
>  From which I get the following result -->
> datetime.timedelta(-1, 45312, 918000).
>
>
> I then apply the formula "t.seconds/3600" and get the result "12" hrs (which is incorrect).

Did you forget do take into account the days member of your timedelta ?

-1 day + 12 hours = 12 hours


-- 
Ghislain LEVEQUE - Clarisys Informatique
http://www.clarisys.fr - 09 72 11 43 60


In response to

Responses

psycopg by date

Next:From: Raheem SarcarDate: 2012-07-26 10:15:32
Subject: Re: Inconsistent results when calculating "age" of db records
Previous:From: Raheem SarcarDate: 2012-07-26 09:51:36
Subject: Re: Inconsistent results when calculating "age" of db records

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group