Calculate days between two dates

[spighita]

Hi:
How can I calculate the days between two dates with mysql.

I have the function

SELECT PERIOD_DIFF(200312,200311)

But that only calculates months, is there one the calculates days?
Or is there another way of doing it?

Thanks in advance for anyone who helps

[Sxooter]

What version are you running? Later versions should deliver an interval of days when you subtract one date from another.

[spighita]

MySQL 3.23.56

[Sxooter]

Any answers here that look good:

http://www.mysql.com/doc/en/Date_calculations.html