Posted By

assbach on 02/25/07

Tagged

2 people have marked this snippet as a favorite

/ Published in: SQL

2 things here. currency (euro) with in a 2.00 format and select entries older than 4 weeks = 28 days

SELECT 
FORMAT(kontoinfo.betrag,2) AS betrag
FROM konto
WHERE user = '".$uid."'
AND konto.datum >= SUBDATE( NOW(), 28)
ORDER BY konto.datum DESC

Posted By: meme on June 22, 2009

SELECT createddate, email FROM customers WHERE (createddate >= CURDATE() - INTERVAL 1 DAY)

Note: you can change the 1 to any number of days.

Comment:

You need to login to post a comment.