Re: Averaging dates
From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Wed, 17 Jul 2002 04:26:02 GMT
Message-ID: <tl6Z8.64246$uw.35157_at_rwcrnsc51.ops.asp.att.net>
Date: Wed, 17 Jul 2002 04:26:02 GMT
Message-ID: <tl6Z8.64246$uw.35157_at_rwcrnsc51.ops.asp.att.net>
What the heck is the average of a series of dates?
Sounds like you are trying to average a series of colors.
Do you mean what is the average number days from now?
eg select avg(sysdate-hiredate) from employee
Jim
"Ron Gardiner" <rongardiner_at_shaw.ca> wrote in message
news:WB4Z8.61099$BD1.5521513_at_news1.calgary.shaw.ca...
> Hope someone can help...
>
> How do I average a column of datatype date?
>
> SELECT AVG(HIREDATE) FROM EMPLOYEE; doesn't work.
>
> TIA!
>
>
>
Received on Wed Jul 17 2002 - 06:26:02 CEST