datetime - 10 secondi

[piero.mac]

oppure:

SELECT date_format(NOW() - interval '00 10' minute_second,' %Y-%m-%d %H:%i:%s') as data1, 
date_format(NOW(), ' %Y-%m-%d %H:%i:%s') as data2

data2 e' tanto per verificare....