Bastiaan Olij <lists(at)basenlily(dot)nl> writes:
> What I'm trying to do is get the difference between two dates either in
> minutes, hours, days, months or years.
Well, you can get the difference in seconds using EXTRACT(EPOCH FROM
timestamp_difference) and then do your own arithmetic ...
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Bruce Hyatt||Date: 2008-12-25 20:00:24|
|Subject: Re: Fw: Re: connection refused|
|Previous:||From: Bastiaan Olij||Date: 2008-12-23 23:02:06|
|Subject: Difference between dates|