SELECT older than x days - SQL Snipplr Social Repository

Revision: 2465

at February 25, 2007 08:32 by assbach

Initial Code

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

Initial URL

Initial Description

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

Initial Title

SELECT older than x days

Initial Tags

mysql, date

Initial Language

SQL