Re: Averaging dates
From: Charlie Edwards <Charlie3101_at_hotmail.com>
Date: 17 Jul 2002 05:54:11 -0700
Message-ID: <db479d88.0207170454.6581ae0e_at_posting.google.com>
Date: 17 Jul 2002 05:54:11 -0700
Message-ID: <db479d88.0207170454.6581ae0e_at_posting.google.com>
"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!
How about
SELECT SYSDATE-(AVG(SYSDATE-hiredate)) FROM employee;
CE Received on Wed Jul 17 2002 - 14:54:11 CEST