[SQL] Zeiträume abfragen

[mkinzler]

Welches DBMS?
select count(gid) from gespraech where kid=1 and Datum between now and <Now - 1 Jahr>;