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

interval in days

From: Tomka Gergely <tomka(at)zeus(dot)gau(dot)hu>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: interval in days
Date: 2003-08-25 08:14:55
Message-ID: Pine.LNX.4.33.0308251012410.13781-100000@zeus.gau.hu (view raw or flat)
Thread:
Lists: pgsql-novice
date_part('epoch', date_trunc('day', TIMESTAMP 'now') -
date_trunc('day', hiba.datum)) / (60*60*24)

I hope there are a simple solution for this - i want to know the age of
hiba.datum, in days. If one year old, then i need 365.

-- 
Tomka Gergely
"S most - vajon barbárok nélkül mi lesz velünk?
Ők mégiscsak megoldás voltak valahogy..."


Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2003-08-25 14:45:36
Subject: Re: interval in days
Previous:From: Mike CastleDate: 2003-08-25 03:39:25
Subject: Re: Clusters and pgsql

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