ding attachments.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Bruno Wolff III
Sent: Monday, February 28, 2005 10:25 AM
To: Joel Fradkin
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] diference in dates in minutes
On Mon, Feb 28, 2005 at 09:09:09 -
roy
all copies of the original message, including attachments.
-Original Message-
From: Bruno Wolff III [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 27, 2005 12:54 AM
To: Joel Fradkin
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] diference in dates in minutes
Discussions along th
On Mon, Feb 28, 2005 at 09:09:09 -0500,
Joel Fradkin <[EMAIL PROTECTED]> wrote:
> Yea I probably forgot respond to all. I agree (specialy for this topic).
>
> In any case, I have dates not time (dates with times).
It really helps if you use precise language when discussing problems.
date, time
From: Bruno Wolff III [mailto:[EMAIL PROTECTED]
> Sent: Saturday, February 26, 2005 4:16 PM
> To: Joel Fradkin
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] diference in dates in minutes
>
> On Sat, Feb 26, 2005 at 15:14:02 -0500,
> Joel Fradkin <[EMAIL PROTECTED]>
You probably want to convert the dates to timestamps, subtract them to
get an interval, extract the epoch to get timme in seconds and then divide
by 60 to get time in minutes.
The converting date to timestamp part isn't trivial. You need to decide
on what you mean when you do this. If you really h
On Sat, Feb 26, 2005 at 15:14:02 -0500,
Joel Fradkin <[EMAIL PROTECTED]> wrote:
> You probably want to convert the dates to timestamps, subtract them to
> get an interval, extract the epoch to get timme in seconds and then divide
> by 60 to get time in minutes.
>
> The converting date to timesta
On Thu, Feb 24, 2005 at 17:34:08 -0500,
Joel Fradkin <[EMAIL PROTECTED]> wrote:
> Sorry for being redundant (I asked this a while back).
> I was looking for in days before and used date math
> Date1::date - date2::date returned the days which was fine for my original
> question.
> I did get a rep
Sorry for being redundant (I asked this a while back).
I was looking for in days before and used date math
Date1::date - date2::date returned the days which was fine for my original
question.
I did get a reply mentioning the age function and he mentioned I could get
minutes etc.
I looked up age in
