DATEDIFF vs. DELETE

Opet problem z DATEDIFF

DELETE shop_cart_users, shop_cart_goods
FROM shop_cart_users, shop_cart_goods
WHERE type = 'GUEST'
AND DATEDIFF(NOW(), date) > 30
AND shop_cart_users.id = shop_cart_goods.id_user";

jde o to nejak nahradit datediff aby to fungovalo ... take bych mohl pridat vyzvu adminum aby Ty verze aktualizovali alespon a 4.3 data zustanou a funkce pribydou

Moc Vam dekuji za pripadnou pomoc

Opet problem z DATEDIFF

DELETE shop_cart_users, shop_cart_goods
FROM shop_cart_users, shop_cart_goods
WHERE type = 'GUEST'
AND DATEDIFF(NOW(), date) > 30
AND shop_cart_users.id = shop_cart_goods.id_user";


no jo no, kdyz tam clovek zapomene zavorku

WHERE type = 'GUEST'
AND (to_days(now())-to_days(date)) > 30

a je to