Can I get an AVERAGE from a DATETIME field?

[LeonelSanchezJr]

Can I get an AVERAGE from a DATETIME field?

 

[fluteplr]

That was interesting.

This seems to work but I have not tested it extensivly.

dateadd(day,avg(datediff(day,'1900-01-01',mydate)),'1900-01-01')

 

[LeonelSanchezJr]

How does the '1900-01-01' fit in to this formula?

 

[fluteplr]

it is an arbitary date to get the difference from. Probably any date would do.

Since sql server won't average a date. I am using datediff to calculate the number of days from an arbitrary date 1/1/1900, and averaging that. DateAdd changes that number back to a date.