SELECT NOW();
SELECT NOW() + 0;
SELECT NOW(), SLEEP(5), NOW();
SELECT SYSDATE(), SLEEP(5), SYSDATE();
-- mysql now minus 1 hour SELECT (NOW() - INTERVAL 1 HOUR) 'NOW - 1 hour', NOW(), -- mysql now plus 1 hour NOW() + INTERVAL 1 HOUR 'NOW + 1 hour';
-- mysql now minus 1 day SELECT (NOW() - INTERVAL 1 DAY) 'NOW - 1 day', NOW(), -- mysql now plus 1 day (NOW() + INTERVAL 1 DAY) 'NOW + 1 day';