| Subject | Re: i want to this ; select avg(datefield) from ... but what? |
|---|---|
| Author | Orhan TURHAN |
| Post date | 2008-05-21T15:07:46Z |
this is a solution.
select cast(cast('01.01.1900' as date)+avg(datediff(day,
cast('01.01.1900' as date), datefield)) as date) from tablename
select cast(cast('01.01.1900' as date)+avg(datediff(day,
cast('01.01.1900' as date), datefield)) as date) from tablename