tijd in db

$db_ = mysql_query("SELECT * FROM datumtest WHERE datum BETWEEN 2010-03-20 AND 2010-03-30") or die(mysql_error());
while($datum = mysql_fetch_array($db_)) {

echo ''.$datum['login'].' datum: '.$datum['datum'].' <br><br>';
}

$db_ = mysql_query("SELECT * FROM datumtest WHERE datum BETWEEN 2010-03-20 AND 2010-03-30") or die(mysql_error());
while($datum = mysql_fetch_array($db_)) {
 
echo ''.$datum['login'].' datum: '.$datum['datum'].' <br><br>';
}

SELECT * FROM data WHERE datumveld >= NOW() - INTERVAL 1 MONTH

SELECT * FROM DATA WHERE datumveld >= NOW() - INTERVAL 1 MONTH

DELETE FROM data WHERE datumveld < NOW() - INTERVAL 1 MONTH

DELETE FROM DATA WHERE datumveld < NOW() - INTERVAL 1 MONTH

DELETE FROM data WHERE datumveld < NOW() - INTERVAL 1 MONTH AND activated = '0'

DELETE FROM DATA WHERE datumveld < NOW() - INTERVAL 1 MONTH AND activated = '0'

$db_ = mysql_query("
SELECT * FROM datumtest 
WHERE datum BETWEEN 1270029000 AND 1270054000") 
or die(mysql_error());

$db_ = mysql_query("
SELECT * FROM datumtest 
WHERE datum BETWEEN 1270029000 AND 1270054000") 
or die(mysql_error());