what is the right sql command to get day difference?

From: Pascal Schmidt-Volkmar (nospam_at_schmidt-volkmar.com)
Date: 03/27/04


Date: Sat, 27 Mar 2004 15:31:22 +0100

Hi there,

I need to select those datasets that are older than a year.

I tried: "SELECT * FROM Abrechnung WHERE (ab_datum-date)>365

but nothing happened.

What should I do??

Thanks,

Pascal