datetime - 10 secondi

[marketto]

SELECT * FROM tabella where date = DATE_FORMAT(FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()-10)),"%Y-%m-%d %H:%i:%s");