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: (view raw, whole thread or download thread mbox)
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..."


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-2017 The PostgreSQL Global Development Group