]>
Cc: "Felipe D. Ramalho" <[EMAIL PROTECTED]>
Sent: Wednesday, November 20, 2002 3:09 PM
Subject: Re: datetime arithmetic
> On 20 Nov 2002, at 14:40, Felipe D. Ramalho wrote:
>
> > SELECT ..., B.dthr_occurrence as open,
> > DATE_SUB(C
On 20 Nov 2002, at 15:30, Felipe D. Ramalho wrote:
> Sorry, but I've omitted part of the where clause to make the message shorter
> and now I see that it was important. Here goes the select again:
>
> SELECT A.cod_call, A.cod_link, A.nr_call , A.status,
>B.dthr_occurrence as open,
>
-- Original Message -
From: "Keith C. Ivey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Felipe D. Ramalho" <[EMAIL PROTECTED]>
Sent: Wednesday, November 20, 2002 3:09 PM
Subject: Re: datetime arithmetic
> On 20 Nov 2002, at 14:40, Felipe D. Ramalho
On 20 Nov 2002, at 14:40, Felipe D. Ramalho wrote:
> SELECT ..., B.dthr_occurrence as open,
> DATE_SUB(C.dthr_occurrence, INTERVAL B.dthr_occurrence
> HOUR_MINUTE) AS during,
> DATE_SUB(D.dthr_occurrence, INTERVAL B.dthr_occurrence
> HOUR_MINUTE) AS late
>
> FROM CALL A
