Re: Date Duration Numbers

From: John Nix <maximum(at)shreve(dot)net>
To: Jason Earl <jason(dot)earl(at)simplot(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Date Duration Numbers
Date: 2002-07-09 17:55:36
Message-ID: Pine.LNX.4.44.0207091255090.28748-100000@server.sblug.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 9 Jul 2002, Jason Earl wrote:

> test=> SELECT sum(end_date - start_date) AS total_days FROM test;
> total_days
> ------------
> 15
> (1 row)
>
> Is this what you are looking for?
>

Exactly... Thanks...

John

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Chad Thompson 2002-07-09 18:01:56 views and rules
Previous Message Jason Earl 2002-07-09 17:45:12 Re: Date Duration Numbers