Re: datetime arithmetic

2002-11-20 Thread Felipe D. Ramalho
]> 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

Re: datetime arithmetic

2002-11-20 Thread Keith C. Ivey
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, >

Re: datetime arithmetic

2002-11-20 Thread Felipe D. Ramalho
-- 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

Re: datetime arithmetic

2002-11-20 Thread Keith C. Ivey
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

datetime arithmetic

2002-11-20 Thread Felipe D. Ramalho
Hi, I'd like to obtain the number of hours and minutes between two fields datetime and I'm trying to proceed just like the documentation says. SELECT ..., B.dthr_occurrence as open, DATE_SUB(C.dthr_occurrence, INTERVAL B.dthr_occurrence HOUR_MINUTE) AS during, DATE_SUB(